Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Controlling editing and drop down of a vba combobox


  • Please log in to reply

#1
brk2000

brk2000

    Member

  • Member
  • PipPip
  • 22 posts
I am using VBA (inside of Microsoft Dynamics GP 9.0) and I'm looking for a way to prevent users from changing the text/value of the combobox. However, they still need to be able to click on the drop down list to select a value from the list. If I change the lock or enable properties, the drop down becomes disabled for the combobox. Any coding suggestions? Or perhaps there is a property I'm overlooking?

Thanks in advance for the help.
  • 0

Advertisements


#2
officialblueboys

officialblueboys

    Member

  • Member
  • PipPipPip
  • 138 posts
Combo box has the preoperty of text and listbox . I fu want that user can't edit or add new items then better use LIST BOX
  • 0

#3
brk2000

brk2000

    Member

  • Topic Starter
  • Member
  • PipPip
  • 22 posts
Thanks for the help...works great!
  • 0

#4
officialblueboys

officialblueboys

    Member

  • Member
  • PipPipPip
  • 138 posts
ur welcome :whistling:
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP