×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

CombBox data

CombBox data

CombBox data

(OP)
I have a form for an Excel workbook with a list which will change periodically. My textbook on VBA notes that the data for the comboBox can be linked to spreadsheet data but does not describe how to do this.

I am going to write some code to open a specific workbook and tranfer the data in the workbook to the comboBox but I was hoping that there would be a shortcut for this already in place.

Thanks.

RE: CombBox data

In design mode right-click on the ComboBox and select Properties. Look for the ListFillRange property and set it to the range containing the values you want in the ComboBox. The selected value will be returned to the cell in the LinkedCell property

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

RE: CombBox data

(OP)
I do not have that property available to me. There doesn't seem to be any choice in the properties window which would do what I need.

I did manage to write a simple loop which inserts the values needed, but the loop I wrote seems to be an awkward solution to a simple problem.

The most complicated thing about this is that some of the data I have to paste into the combobox is located in a different workbook.

Thanks.

RE: CombBox data

What version of Excel are you using?

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources