Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread Chaya Cooper
I guess that's good to know On Tuesday, August 20, 2013 2:23:33 AM UTC-4, ashish wrote: > > Hi > > Excel 2008 mac does not support VBA . > http://en.wikipedia.org/wiki/Microsoft_Office_2008_for_Mac > > http://www.mac-forums.com/forums/switcher-hangout/159791-excel-2008-no-vba.html > > It might b

Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-08-19 Thread ashish koul
I don't have any knowledge about Mac Excel . So can't help you much :( On Tue, Aug 20, 2013 at 12:01 PM, Chaya Cooper wrote: > For some reason it doesn't work when I do that :-( Any suggestions? >> >> > Also, is there a way to do it for all the images at once? (Not sure if it > helps, but they

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread Chaya Cooper
Alt + Fn +F11 just minimizes the window :-( On Tuesday, August 20, 2013 2:17:28 AM UTC-4, ashish wrote: > > if you are using mac excel then try Alt + Fn +F11 > > source: > http://www.excel4mac.com/2010/01/shortcut-to-access-visual-basic-editor.html > > > On Tue, Aug 20, 2013 at 11:43 AM, ashish

Re: $$Excel-Macros$$ Vba macro code for generating years along the side of days and also by removing the months

2013-08-19 Thread ashish koul
see if it helps Sub sample() Dim i As Long Dim st As Long Dim j As Long j = 3 st = 1936 For i = 2 To Range("a65356").End(xlUp).Row If IsNumeric(Cells(i, 1).Value) And Cells(i, 1).Value <> "" Then If Cells(i, 1).Value = st + 1 Then st = st + 1 Cells(j, 10).Value = st Cells(j, 11).Va

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread Chaya Cooper
I guess that's good to know. Unfortunately I'm only using this this computer temporarily, so I'm not able to upgrade the software :-( On Tue, Aug 20, 2013 at 2:31 AM, P.VIJAYKUMAR wrote: > Respected Chaya, > > Unfortunately macros or VBA interface is not available with Excel 2008 for > MAC.You

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread P.VIJAYKUMAR
Respected Chaya, Unfortunately macros or VBA interface is not available with Excel 2008 for MAC.You must upgrade to Excel 2011 of chane to windows operating system to use Excel 2007,2010 or Excel 2013.The shortcoming or limitations of Excel 2008 are given in the below link. http://en.wikipedia.org

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread ashish koul
Hi Excel 2008 mac does not support VBA . http://en.wikipedia.org/wiki/Microsoft_Office_2008_for_Mac http://www.mac-forums.com/forums/switcher-hangout/159791-excel-2008-no-vba.html It might be reason that its not thr in right click Regards Ashish On Tue, Aug 20, 2013 at 11:47 AM, ashish ko

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread ashish koul
if you are using mac excel then try Alt + Fn +F11 source: http://www.excel4mac.com/2010/01/shortcut-to-access-visual-basic-editor.html On Tue, Aug 20, 2013 at 11:43 AM, ashish koul wrote: > press alt +f11 > > > On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR wrote: > >> Respected Chaya Cooper,

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread ashish koul
press alt +f11 On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR wrote: > Respected Chaya Cooper, > > Please check the following link and see whether it helps. > http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/ > > To view code you can also open the VBA window by pressing ALT+F11 and g

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread Chaya Cooper
Vijaykumar, That's actually a great tutorial, so thank you for showing it to me :-) Unfortunately it doesn't show how to view the code :-( When I select ALT+F11 nothing happens (is there another way that i need to do it in Mac?), and I'm having trouble figuring out another way to open it. Any

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread P.VIJAYKUMAR
Respected Chaya Cooper, Please check the following link and see whether it helps. http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/ To view code you can also open the VBA window by pressing ALT+F11 and go to project explorer window and go to the module folder to open it and see the cod

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread ashish koul
have you tried using form controls or active x control list box for multi select options On Tue, Aug 20, 2013 at 10:57 AM, Chaya Cooper wrote: > And these are the options that are displayed when I right-click on the tab > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread ashish koul
=OFFSET('Sample - Unedited'!$A$1,COLUMN('Sample - Edited'!A1)+(COUNTA($A$1:$C$1)*(ROW(A1)-1)),0) 'Sample - Unedited'!$A$1 - header of source column COLUMN('Sample - Edited'!A1) - will give us 1 , 2 , 3 (COUNTA($A$1:$C$1)*(ROW(A1)-1)) will give us 0 , 3, 6 ' 0 because source data is in same col

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Prashant Pednekar
Dear Chaya The solution from Ashish (using offset command) has lesser effort than using macro. I suggest to use the same for your multiple entries. using macro is possible in 2008 . no issue. For your information. you have to use Ctrl+ shift + A at first column of each row required. Regards Pra

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
Ashish, That's exactly what I needed :-D Would you mind showing me how to use it? - Chaya On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote: > > Hi try the attachment . see if it helps > > > > > On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar > > > wrote: > >> Hi Chaya, Prabhu,

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
Hi Prashant, I've only used macros a few times, and am having trouble a wee bit of trouble figuring things out because I'm temporarily using a Excel 2008 for Mac :-( (I'm normally a PC gal, with Office 2007 ;-)) Can I trouble you to explain when I should use Control + Shift + A, and how to op

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread ashish koul
Hi try the attachment . see if it helps On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar wrote: > Hi Chaya, Prabhu, > > Done with a simple macro. > > Use Control + Shift + A at particular cell where you want to transpose. > > This you have to to for every entry. > > In case you want it for

Re: $$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread अनिल नारायण गवली
Dear Chaya, Pl share a sample sheet with us. Warm Regards, Gawli Anil. Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Aug 20, 2013 at 6:00 AM, Chaya Cooper wrote: > A tutorial I'm using (to create a multi-select box) suggests right-clicking

Re: $$Excel-Macros$$ Changing txtbox backcolor when linked cell value changes...

2013-08-19 Thread अनिल नारायण गवली
Dear Ashkan, on textbox enter event write a code Me.txtshiptoparty.BackColor = vbGreen after on textbox exit event write again the same code with different color. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Tue, Aug 20,

Re: $$Excel-Macros$$ Changing txtbox backcolor when linked cell value changes...

2013-08-19 Thread ashish koul
can u share a sample file On Tue, Aug 20, 2013 at 3:38 AM, ashkan kordmahaleh wrote: > I am trying to use some VBA to change backcolor of my userform txtbox when > the linked cell value changes. Any ideas? > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME

Re: $$Excel-Macros$$ Folder Query (urgrnt)

2013-08-19 Thread ashish koul
try this Sub choose_file() Dim flname As String Dim fd As FileDialog, fl As Variant Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .AllowMultiSelect = True .Title = "Please choose the file" .Filters.Add "Excel Files", "*.xls*", 1 .

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Prabhu Pinky
Am just asking you to share the excel file. On 20-Aug-2013 5:50 AM, "Chaya Cooper" wrote: > I'm sorry, I'm not sure I understand what you're saying :-( > > On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote: >> >> hi chaya, >> >> hope if u share the file.. it will be so fine to work.

$$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-19 Thread Chaya Cooper
A tutorial I'm using (to create a multi-select box) suggests right-clicking on the sheet tab to View Code, but that option isn't being displayed (I'm running Excel 2008 for Mac). Any suggestions how I can view the code? My apologies for what is probably a simple issue, but I've been unable to

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
I'm sorry, I'm not sure I understand what you're saying :-( On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote: > > hi chaya, > > hope if u share the file.. it will be so fine to work. > > > Thanks & Regards, > Prabhu R > > > On 20 August 2013 04:35, Chaya Cooper >wrote: > >> Unfortun

Re: $$Excel-Macros$$ Need help - How to enter the text in the cells of column by using textbox in userform

2013-08-19 Thread De Premor
paste this on userform1 ' Dim Target As Range Private Sub CommandButton1_Click() Target.Offset(1).Select Unload Me End Sub Private Sub TextBox1_Change() Target = TextBox1.Text End Sub Private Sub UserForm_Activate() Set Target = Selection TextBox1.Text = Tar

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Prabhu Pinky
hi chaya, hope if u share the file.. it will be so fine to work. Thanks & Regards, Prabhu R On 20 August 2013 04:35, Chaya Cooper wrote: > Unfortunately, the data in each row is different > > I've attached an image with an example :-) > > > On Mon, Aug 19, 2013 at 6:36 PM, Prabhu Pinky wrote

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Prabhu Pinky
you mean same data in each row..?.. or can you share me your file with requirement..? like below.. [image: Inline images 1] Thanks & Regards, Prabhu R On 20 August 2013 04:02, Chaya Cooper wrote: > That's amazing :-D I'm sorry I waited this long to ask ;-) > > One question - is there a way

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
That's amazing :-D I'm sorry I waited this long to ask ;-) One question - is there a way to split it up into several rows (for example 5 rows, with 3 columns per row)? On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote: > > Hi Chaya, > > You no need to cut and paste the each cells.

Re: $$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Prabhu Pinky
Hi Chaya, You no need to cut and paste the each cells. Simply u just copy the data which u need to be in row. then right click->paste special->values (and select transpose). Now you data will be pasted in single row. Note the same method u can use to copy the data in single column if it is in sin

$$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-08-19 Thread Chaya Cooper
I often use Excel to organize rows of text (i.e. terminology, examples, subsets, etc.) and often need to include images in a row. However since images aren't actually in a specific cell they therefore aren't linked to the rest of the information in the row, making it impossible to sort the data

$$Excel-Macros$$ Changing txtbox backcolor when linked cell value changes...

2013-08-19 Thread ashkan kordmahaleh
I am trying to use some VBA to change backcolor of my userform txtbox when the linked cell value changes. Any ideas? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discusse

$$Excel-Macros$$ How can I change selected cells from a column into a row?

2013-08-19 Thread Chaya Cooper
I often have to move cells in order to have them in a row (going across) instead of in a column (going down). Is there a way to simplify this so that I don't have to manually cut & paste or move each cell? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,

$$Excel-Macros$$ Need help - How to enter the text in the cells of column by using textbox in userform

2013-08-19 Thread Mangesh Vimay
Hi Friends, Please suggest me vba code to enter the text in A1, A2, A3..likewise by using VBA Userform textbox. I have attached sample file for you reference. Double click on cell A1, A2 will open the useform for which I need the code. Thanks in advance. -- With regards, *MaNgEsH* -- Are you

Re: $$Excel-Macros$$ Macro for COPY Paste

2013-08-19 Thread Shrinivas Shevde
Dear Ahsish waiting for help Regards Shrinivas On Sat, Aug 17, 2013 at 11:50 AM, Shrinivas Shevde wrote: > Dear Ashish > Please find attached File > > Regards > Shrinivas > > > On Sat, Aug 17, 2013 at 9:41 AM, ashish koul wrote: > >> Hi can u share some sample files and output workbook >> >> >

Re: $$Excel-Macros$$ Need urgent help on macro error.

2013-08-19 Thread Shrinivas Shevde
Dear Indarjit Can you share a file with me because I have the same work Regards Shrinivas On Mon, Aug 19, 2013 at 2:33 PM, Indrajit $nai wrote: > Thanks a lot to both of you. > > You guys are simply awesome :) > > > On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi wrote: > >> add below "M

Re: $$Excel-Macros$$ Need urgent help on macro error.

2013-08-19 Thread Indrajit $nai
Thanks a lot to both of you. You guys are simply awesome :) On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi wrote: > add below "Microsoft Scripting Runtime" library from tool-->reference > > > -- > *From:* Indrajit $nai > *To:* excel-macros@googlegroups.

Re: $$Excel-Macros$$ Folder Query (urgrnt)

2013-08-19 Thread अनिल नारायण गवली
Dear Shrinivas, Pl see that u have filter the ext with the following one. .Filters.Add "Excel", "*.xls; *.xlsx; *.xlsm; *.xlsb", 1 Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Mon, Aug 19, 2013 at 2:24 PM, Shrinivas

$$Excel-Macros$$ Folder Query (urgrnt)

2013-08-19 Thread Shrinivas Shevde
Dear All I am facing a small problem I like to have help for expert. I am trying to write a macro which will browse the folder and open the selected file one by one. But whenever I am opening a folder from macro I could not see any file in that folder. If I am opening the same folder directly there

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-19 Thread ravinder negi
PFA.There are three argument in UDF first lookup value , lookarea(range),colnum From: Rashid Khan To: excel-macros@googlegroups.com Sent: Sunday, August 18, 2013 9:32 PM Subject: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

Re: $$Excel-Macros$$ Need urgent help on macro error.

2013-08-19 Thread ravinder negi
add below "Microsoft Scripting  Runtime" library from tool-->reference From: Indrajit $nai To: excel-macros@googlegroups.com Sent: Monday, August 19, 2013 4:08 AM Subject: $$Excel-Macros$$ Need urgent help on macro error. Hi All, Kindly find attached the

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-19 Thread prkhan56
Hello, Thanks for the reply. Output required is group concatenate. As you can see I have shown that in the sample file. Codes are used to mark the questions. Then it will come as an output in the Answers Column. I need to get the concatenated values from the Text Columns Hope it is clear Regards