Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To change command button caption
Dear All
I am in sheet2. I click a custom tool bar item, then it has to goto sheet1 and change command button in sheet1 by name 'alfa" caption from "go to ballast" to "go to cargo" . Have been getting error when using activesheet.shapes.("alfa").caption= "go to cargo" Pls suggest right code n thnks brgds/captgnvr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
To change command button caption
Sorry- figured it out and the below code works.
ActiveSheet.OLEObjects("alfa").Object _ ..Caption = "GO TO CARGO" can consider this thread closed. "CAPTGNVR" wrote: Dear All I am in sheet2. I click a custom tool bar item, then it has to goto sheet1 and change command button in sheet1 by name 'alfa" caption from "go to ballast" to "go to cargo" . Have been getting error when using activesheet.shapes.("alfa").caption= "go to cargo" Pls suggest right code n thnks brgds/captgnvr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button Caption - VBA | Excel Programming | |||
command button caption | Excel Programming | |||
using vba to change command button caption | Excel Programming | |||
Command Button Caption | Excel Programming | |||
Change Caption of Forms Command Button | Excel Programming |