Setting default value in vba created FormTool Dropdown

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try...
dropdown.text = activecell.value

I'm assuming you are creating the dropdown in the change selection event.
 
Yes, that works although the syntax should be

dropdowns.text = activecell.value

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set value of a cell with a dropdown list during run time (C#) 10
Start value of dropdown 1
vba Syntax? 1
Dynamic dropdown? 1
Conditional formatting and Dropdowns 1
Select item in dropdown using VBA 3
dropdown issue 5
Dropdown list instead of Inputbox 2

Back
Top