Results 1 to 3 of 3

I have a button that runs a macro - I want to increase the size of the button

Threaded View

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    2

    I have a button that runs a macro - I want to increase the size of the button

    Hi, I am an excel 2003 user - not a pro by any means, just know the basics to get done what I need to get done - most of the time.

    I think that it is a command button as this is the only reference I can find to it in the code. The code is much longer but doesn't appear to be referencing anything to do with the button format more the running of the macro after clicking it.

    Private Sub CommandButton1_Click()
    
        Dim myRange, myRecursiveRange, myMonth As Range
        Dim intNumSaleArea, intForest As Integer
        Application.Cursor = xlWait
        Worksheets("Data Table").Select
    I just want to make the button bigger - it used to also have text on it but the button is now so tiny that you can only just click on it to run the macro. Any help or suggestions would be much appreciated.

    Thanks in advance.
    Last edited by jeffreybrown; 01-08-2013 at 07:56 PM. Reason: Please use code tags...Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1