+ Reply to Thread
Results 1 to 13 of 13

get caption of the button you click

  1. 04-09-2013, 01:51 PM #1
    pankajy18 is offline
    Registered User
    Join Date
    02-20-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    43

    get caption of the button you click

    how to get the caption of the button that is clicked say in a cell

    Also how to extract the number from it

    Please Suggest something
    Reply With QuoteRegister To Reply
  2. 04-09-2013, 01:54 PM #2
    AndyLitch is offline
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: get caption of the button you click 

    Please Login or Register  to view this content.
    Elegant Simplicity............. Not Always
    Reply With QuoteRegister To Reply
  3. 04-10-2013, 06:47 AM #3
    pankajy18 is offline
    Registered User
    Join Date
    02-20-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: get caption of the button you click

    Thanks AndyLitch ........sorry for not explaining in detail but the problem is a bit different......

    I want to use a common macro for a number of buttons and hence i don't know the button name i.e. i can't use CommandButton2.Caption.

    Any suggestions
    Reply With QuoteRegister To Reply
  4. 04-10-2013, 06:54 AM #4
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: get caption of the button you click

    If the buttons are Form buttons assign this macro to each of them.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  5. 04-10-2013, 07:57 AM #5
    pankajy18 is offline
    Registered User
    Join Date
    02-20-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: get caption of the button you click

    Thanks Norie.....exactly what i needed

    Is there a way such that i can take the number in Caption string....say UPLOAD19 is caption how can i get number 19 from it.......
    Reply With QuoteRegister To Reply
  6. 04-10-2013, 08:00 AM #6
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: get caption of the button you click

    Does the caption always begin with UPLOAD?

    If it does then you can use Mid.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 04-10-2013, 08:56 AM #7
    pankajy18 is offline
    Registered User
    Join Date
    02-20-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: get caption of the button you click

    Thanks a lot norie
    Reply With QuoteRegister To Reply
  8. 04-10-2013, 09:23 AM #8
    pankajy18 is offline
    Registered User
    Join Date
    02-20-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: get caption of the button you click

    PLEASE EXPLAIN....ITS giving Error 438
    object doesn't support this property or method
    Reply With QuoteRegister To Reply
  9. 04-10-2013, 09:23 AM #9
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: get caption of the button you click

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Reply With QuoteRegister To Reply
  10. 04-10-2013, 10:15 AM #10
    pankajy18 is offline
    Registered User
    Join Date
    02-20-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: get caption of the button you click

    PFA the excel file....attach document_10th.xls

    i want to use this number for my upload and delete button code.....where i can delete the inserted oleobject by taking reference from the number.
    Reply With QuoteRegister To Reply
  11. 04-10-2013, 10:20 AM #11
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: get caption of the button you click

    Sorry, I'm not following.

    Where/when are you getting the error you describe in the previous post?

    Is it actually in the code I posted?
    Reply With QuoteRegister To Reply
  12. 04-10-2013, 11:22 AM #12
    pankajy18 is offline
    Registered User
    Join Date
    02-20-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: get caption of the button you click

    click UPLOAD1 and u will get it....
    Reply With QuoteRegister To Reply
  13. 04-10-2013, 11:35 AM #13
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: get caption of the button you click

    It's a typo, it should be this.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1