Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
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