| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting default value in vba created FormTool Dropdown
I have adapted vba code to create a formtool DropDown when a particular cell
is selected. This is working, but I would like to get the dropdown to display the existing cell value when the dropdown is activated. However, the dropdown defaults to blank which covers the existing cell value. Any way around this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting default value in vba created FormTool Dropdown
Try...
dropdown.text = activecell.value I'm assuming you are creating the dropdown in the change selection event. -- JNW "joeeng" wrote: I have adapted vba code to create a formtool DropDown when a particular cell is selected. This is working, but I would like to get the dropdown to display the existing cell value when the dropdown is activated. However, the dropdown defaults to blank which covers the existing cell value. Any way around this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting default value in vba created FormTool Dropdown
Yes, that works although the syntax should be
dropdowns.text = activecell.value Thanks "JNW" wrote: Try... dropdown.text = activecell.value I'm assuming you are creating the dropdown in the change selection event. -- JNW "joeeng" wrote: I have adapted vba code to create a formtool DropDown when a particular cell is selected. This is working, but I would like to get the dropdown to display the existing cell value when the dropdown is activated. However, the dropdown defaults to blank which covers the existing cell value. Any way around this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting default filter setting | Charts and Charting in Excel | |||
| How to reference cell created from dropdown list in a combo box? | Excel Discussion (Misc queries) | |||
| Dropdown depend on product with default value | Excel Discussion (Misc queries) | |||
| how do I change font size in a dropdown menu I created? | New Users to Excel | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Linear Mode
