advanced excel courses - Userforms

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

Resolved · Low Priority · Version Standard

Userforms

Jennifer has attended:
Excel VBA course

by - delegate Jennifer [2 posts] (2007 Nov 6 Tue, 09:32) Reply

I am trying to set up a macro with user input, where they can choose one of several options (countries), each country chosen is then used as a variable in the macro (ie. country1, country2 etc). I have set up a checklist on a userform, but I'm not sure how to transfer the checked options to the main macro from the form.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 3 Wed	Bloomsbury	3	book now	£224	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	6	book now	£214	£230
2003	2008 Sep 17 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 126 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: userforms

by - trainer Carlos gold contributer [394 posts] (2007 Nov 26 Mon, 13:14) Edited on 2007 Nov 26 Mon, 13:16 Reply

Hi Jeniffer

The simplest way to do it is to create Public variables in the macro to receive the values from the form.

You could create the variables as an Array eg.

Public Country(5) as Variant .

This will hold 6 values. Now when the countries are selected in the form their names are place in the Array.

Attached is an excel sheet that shows some check boxes that when clicked will add a country name to the array.

Hope it helps

Carlos