Drop Down text won't change

  • Thread starter The ants are driving me crazy
  • Start date
T

The ants are driving me crazy

OK, I used this simple routine to select an item in the "Plan" drop
down box. My problem is that this text will not go away once I select
another item in the drop down. Using the Value property I was able to
verify that the selected item did change, but the drop down box still
says "Plan1". Any tips on what to do about this?

Note, The drop down box text did change until I ran the routine listed
below.

Thanks

Chris


Sub test()

ActiveSheet.DropDowns("Plan").Text = "Plan1"

End Sub
 

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

Top