Excel Macro and a form

  Bramblerose 15:07 27 Oct 2003
Locked

Hi...

I am using an excel spreadsheet to log training - its a spreadsheet that I worked on a long time ago with a colleague - I had the ideas, he did the input!

Anyway, I have a macro which when clicked brings up a user form to input data for new people, ie name, department etc.

I need to get into this form to edit it as the company logo which is on there is now out of date!!

Any ideas? I have had a look at the Visual Basic page that editing the macro brings up but there is nothing that makes any sense to me at all!!

Thanks in advance

  IanNiblock 15:16 27 Oct 2003

If you go to Tools->Macro->Visual Basic Editor you should open a new visual basic window, on the left hand side of this window you should see a Project Window containing a list of Microsoft Excel Objects, one of which should be your form. Double clicking on this form should allow you to edit it.

  Bramblerose 15:25 27 Oct 2003

Sorted!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone