excel consultants - Userform combobox and textbox

Resolved · Low Priority · Version 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:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

excel consultants - Userform combobox and textbox

Userform combobox and textbox

RE: Userform combobox and textbox

Excel articles

Excel tip:

Convert Text into Number