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 VBA

Excel VBA

ResolvedVersion 2003

Tue 13 Dec 2011, 13:48 Delegate 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

Wed 21 Dec 2011, 15:26 Trainer 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

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

RE: Excel VBA

Thanks Simon, thats worked perfectly

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips