Hi,
Is it possible to populate listbox 1 on userform2 from sheets 12 (inclusive) onwards with the value of A3 on each sheet ?
Hi,
Is it possible to populate listbox 1 on userform2 from sheets 12 (inclusive) onwards with the value of A3 on each sheet ?
Last edited by zimbo109; 05-21-2010 at 04:43 PM.
problems will arise if the sheet order is changed,something like
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks Roy, .Index is an invalid or unqualified reference??
Sorry,rushing about at the moment
Please Login or Register to view this content.
Great as always- Thanks Roy.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
or (faster)
Still you can choose the Value property - .cells(3,1) - or - .cells(3.1).Value or the Text property - .cells(3,1).Text - of cell A3.Please Login or Register to view this content.
Last edited by snb; 05-21-2010 at 03:11 PM.
Thanks snb, the value that A3 returns is that also of the sheet name. From the listbox/combobox that is now showing the results of A3 in all ws after sheet 12 can I then select the item so that, that sheet becomes the active sheet?
in that case you can also use:
Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks