excel consultants - Userform combobox and textbox

The UK's most regular instructor-led training courses.
Training information: excel consultants · Excel/courses/london · VBA courses London UK

Resolved · Low Priority · Version Standard

Userform combobox and textbox

David has attended:
Excel Advanced course
Excel VBA course

by - delegate David [2 posts] (2007 Sep 3 Mon, 10:06) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	0	FULL
2003	2008 Oct 23 Thu + 24 Fri	Southwark	0	FULL
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Nov 3 Mon + 4 Tue	Bayswater	4	book now	£475	£485
2003	2008 Nov 17 Mon + 18 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 40 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Userform combobox and textbox

by - trainer David gold contributer [401 posts] (2007 Oct 18 Thu, 14:04) Reply

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

· Do You Really Need Excel VBA Training?
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Microsoft Excel Training: Not Just for Newbies Anymore
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Microsoft Excel Cheat Sheet: Tips and Shortcuts

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips