| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text does not update in rectangle box
Hi,
I want to be able to update the text in the rectangle when the user clicks on it. My code doesn't seem to update the text even though under debugging mode, I can see it updating. Pls help. ActiveSheet.Shapes("Rectangle 2").Select Selection.Characters.Text = "test1 " MsgBox "ts" ActiveSheet.Shapes("Rectangle 2").Select Selection.Characters.Text = "test2 " ActiveCell.Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign a text to a rectangle | Excel Discussion (Misc queries) | |||
| Text Box vs. rectangle, what is the difference? | Excel Discussion (Misc queries) | |||
| Change text in rectangle shape | Excel Programming | |||
| Change text in rectangle shape | Excel Programming | |||
| Add text to a rectangle in VBA | Excel Programming | |||
Threaded Mode
