| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set string variable to word displayed in a combobox
I have a sheet which workouts the names of all other worksheets in another
workbook. A combobox is then populated with these names allowing the user to select one of them. I need to set a string variable to the name the user selects in the combobox so that the rest of my code with run from the data on that sheet. How do I set a variable to hold the string value in the combobox. Many thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set string variable to word displayed in a combobox
Hi Graham
Use like youvar = Sheet1.Combobox1.Text use the text property of combo Thanks Xcelion "Graham Whitehead" wrote: I have a sheet which workouts the names of all other worksheets in another workbook. A combobox is then populated with these names allowing the user to select one of them. I need to set a string variable to the name the user selects in the combobox so that the rest of my code with run from the data on that sheet. How do I set a variable to hold the string value in the combobox. Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to calculate # of times text string is displayed | Excel Worksheet Functions | |||
| WORD-DELIMITED string vba macro for excel/word | Excel Programming | |||
| How can a calculated value be displayed wiyhin a text string | Excel Discussion (Misc queries) | |||
| setting a range variable equal to the value of a string variable | Excel Programming | |||
| How do I convert an integer variable to a string variable? | Excel Programming | |||
Linear Mode
