Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel VBA

Resolved · Medium Priority · Version 2003

Reply Tue 13 Dec 2011, 13:48Delegate Steven said...

Steven has attended:
Excel VBA Intro Intermediate course

Excel VBA

Hi,

I am creating a userform for quality checking work and I would like to have it so that if you click on a certain option button then further options are displayed on the form.

Is there a simple piece of VBA code which will allow me to do this?

Thanks

Steve

For upcoming training course dates see: Pricing & availability

Reply Wed 21 Dec 2011, 15:26Trainer Simon said...

RE: Excel VBA

Hi Steven,

Thank you for your question and welcome to the forum.

I have attached an example spreadsheet with a form created in the VBA window.

Hope this helps.

Regards

Simon

Attached files...

Form Options code.xlsm

Reply Fri 23 Dec 2011, 20:39Delegate Steven said...

RE: Excel VBA

Thanks Simon, thats worked perfectly

Excel articles

· Make A Custom Sort List In Excel
· How To Protect Your Work In Excel 2010
· Update Your VAT Rates In Excel
· How To Pick The Best Chart Type In Excel
· Trust Excel To Protect Your Data

Please browse our web site to find out more about
excel vba courses london and other Microsoft training courses.

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips