| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Changing Button Text
My script is stopping on this line when run on Excel 2007:
Selection.Characters.Text = "Click to Create Weekly File" & Chr(10) & "& Change Date" It works fine in Excel 2003. What change would I need to make so that it runs in both 2007 and 2003? THanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error Changing Button Text
This has come up before.
It appears that the max number of characters that you can add to the caption is 33. (I don't know a way around that limitation (bug????).) So you could change your caption or maybe stick a button on different (hidden???) sheet and just copy it from there (already formatted, too). David wrote: My script is stopping on this line when run on Excel 2007: Selection.Characters.Text = "Click to Create Weekly File" & Chr(10) & "& Change Date" It works fine in Excel 2003. What change would I need to make so that it runs in both 2007 and 2003? THanks! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error Changing Button Text
Thanks much Dave for the options and quick response!
"Dave Peterson" wrote: This has come up before. It appears that the max number of characters that you can add to the caption is 33. (I don't know a way around that limitation (bug????).) So you could change your caption or maybe stick a button on different (hidden???) sheet and just copy it from there (already formatted, too). David wrote: My script is stopping on this line when run on Excel 2007: Selection.Characters.Text = "Click to Create Weekly File" & Chr(10) & "& Change Date" It works fine in Excel 2003. What change would I need to make so that it runs in both 2007 and 2003? THanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing text on a button | Excel Discussion (Misc queries) | |||
| Form Button - Changing Text | Excel Discussion (Misc queries) | |||
| changing button colour | Excel Programming | |||
| button for changing language??? | Excel Programming | |||
| Changing Text in a Forms Button | Excel Programming | |||
Linear Mode
