microsoft excel training company borough high street london - excel vba buttonsimages
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training Sitemap add this page to your favourites/bookmarksBookmark page
 
view a printable version of this pagePrintable version
Plus One Google
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

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

resolvedResolved · Low Priority · Version Standard

replyReplyMon 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

replyReplyFri 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

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

RE: Excel VBA buttons/images

Yes that's exactly right.

replyReplyTue 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 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

forum postI 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..

» Forum post: Microsoft Access


Rate this page:
2.2/5 (213 votes cast)
Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses
Microsoft Certified Partner
Security Seal verified by visa, mastercard securecard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Management training

Professional Skills courses
Project Management Course London
Project Management Courses London
Project Management Training London
Project Management Training
Project Seminar
Project Seminars
Time Management Course London
Time Management London
Time Management Courses London
Time Management Training London
Introduction to Finance course
Assertiveness Skills course
Effective Communications Skills training
Presentation Skills London

Training Formats

Public scheduled courses
On-site training
Closed company courses

Consultancy
Application Development

Blogs

Excel Training
MS Project Training
Microsoft Training Blog

Version differences

Office 2010 vs 2007
MS Project version differences

Training Information

London Computer Training
Computer Training London
Docklands Training Courses
Docklands Training London

Training venues London
Client list
FAQ
Pricing and availability
Course details / Syllabus

Training Articles
Training Information

Microsoft training

Microsoft Office training
& IT Applications

Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training
MS Project courses
MS Project training
Outlook courses
PowerPoint courses
PowerPoint training
VBA courses
Word courses
Microsoft.training
(more...)

Excel Training

Excel courses
Excel Training Courses Medway
Autonumber in Excel
Microsoft Excel training
Basic Excel Courses
Basic Excel Course
Basic Excel Training

Interested in MS Access training?

Access courses
Microsoft Access training
Microsoft access courses
Microsoft training access course
Microsoft+access+training
Access courses in london

Training provider

Training providers
IT training companies
IT training providers
Management Training providers
Management Training provider

Event history, feedback results
Events in 2012 · 2011 · 2010 · More

See also

Crystal Reports training