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

microsoft excel training company borough high street london - excel vba buttonsimages

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

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

ResolvedVersion Standard

Jennifer has attended:
Excel Advanced course
Dreamweaver 8 Introduction course
Dreamweaver 8 Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

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)?

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

RE: Excel VBA buttons/images

Yes that's exactly right.

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

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.