Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created a userform before but it was a long time ago and I don't
have it or the resources I used to create it available, so I need some help. The goal is to have a userform open upon clicking on a custom toolbar button that will have a listbox with "English" names for web pages whose URL is dynamic (www.mysite.com?page=4&dept=74&lang=-1). When a user selects the English name from the dropdown, it will be used to reference both the URL (for a web query - already written and working) and a worksheet that contains data for the webpage. The macro is in a hidden workbook, so I do have the option of creating a table to lookup the values for the English name. I have the userform created with the listbox and buttons on it I need, but I don't know how to load the English names into the listbox, have the listbox pop up, and then how to have the existing macro reference the needed values based on the listbox choice. TIA, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help! Excel Has Gone Nuts! | Excel Discussion (Misc queries) | |||
My Boss is nuts | Excel Worksheet Functions | |||
Need Help, this is driving me nuts | Excel Discussion (Misc queries) | |||
This drives me nuts | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |