excel vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Excel VBA

resolvedResolved · Medium Priority · Version 2003

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

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

RE: Excel VBA

Thanks Simon, thats worked perfectly


 

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips


Server loaded in 0.08 secs.