The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » microsoft excel training company borough high street london - Excel VBA buttons/images

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

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

microsoft excel training company borough high street london - Excel VBA buttons/images

Resolved · Low Priority · Version Standard

ReplyMon 3 Dec 2007, 16:35Delegate Jennifer said...

Excel VBA buttons/images

Can I create a button that is replaced by an image( after it is clicked and the proceedure it runs has run)?

For upcoming training course dates see: Pricing & availability

ReplyFri 14 Dec 2007, 16:28Trainer Andrew said...

RE: Excel VBA buttons/images

Hi Jennifer

Thanks for your question. Can I just check that I have understood your question. A user will click the button. This will run the associated procedure and also remove the button. Finally and image will be displayed where the button was position.

Thanks

Andrew

ReplySat 15 Dec 2007, 19:25Delegate Jennifer said...

RE: Excel VBA buttons/images

Yes that's exactly right.

ReplyTue 26 Feb 2008, 15:38Trainer Stephen said...

RE: Excel VBA buttons/images

Hi Jennifer

Thank you for your question

If you create the command button and the picture on the form.

In the properties form, set the visible property of the button to true, and the visisble property of the picture to false.

Then double click on the button to open the code window for the on click property.

Then enter the following lines of code

Me.cmd1.Visible = False

    Me.Image1.Visible = True

where cmd1 is the name property of the command button, and image1 is the name property of the picture.

I hope this goes someway to solving your problem. If you need to refine things, let me know

Regards

Stephen

Excel articles

· Copy And Paste In Excel
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How To Make Excel Open A Particular File When It Launches
· Basic Excel Training
· How To Disguise Error Messages In Excel 2007/2010

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips

I have two forms, one and two, addressing two related tables, one and two. The connecting key is IDNumber. When working in form one at (say) IDNumber 5 on table one, it wish to open form two displaying IDNumber 5 on table 2.

How can I build an expres..