Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel consultants - Userform combobox and textbox

excel consultants - Userform combobox and textbox

ResolvedVersion Standard

Mon 3 Sep 2007, 10:06 Delegate David said...

David has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Userform combobox and textbox

Hi,

I'm building a userform in excel and am having difficulty with a couple of textboxes and a combobox.

When the User selects an option from the combobox, I would like the 2 textboxes to update with information from the same range the combobox selections are picked from.

I know I can't use vlookup, so how do I do it?!

Many thanks in advance.

Thu 18 Oct 2007, 14:04 Trainer David said...

RE: Userform combobox and textbox

i suggest you contact the office to have one of our vba specialsists talk to you

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel consultants - Userform combobox and textbox

Userform combobox and textbox

RE: Userform combobox and textbox

Excel articles

Excel tip:

Quick Absolute Cell References