| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox - Shape
To input text i textbox I use:
..Shapes("txtbox").TextFrame.Characters.Text = Txtstring 1) If txtstring is a date or number. Can I input as date or number format? (Replace characters.text) 2) If txtstring is i.e. "2". I want to load variable 2 (as number) into variable k. (How to convert "2" (string) to 2(number)). 3) Same as 2 but with dates Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Textbox - Shape
the text in a textbox when used as a value is a string variant data type. To
get it to act as a number you would have to use one of the conversion functions like CLng, CInt, CDbl, etc. "Jarle" wrote: To input text i textbox I use: .Shapes("txtbox").TextFrame.Characters.Text = Txtstring 1) If txtstring is a date or number. Can I input as date or number format? (Replace characters.text) 2) If txtstring is i.e. "2". I want to load variable 2 (as number) into variable k. (How to convert "2" (string) to 2(number)). 3) Same as 2 but with dates Thank you! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Textbox - Shape
Perfect. Exactly what I was looking for!
JLGWhiz skrev: the text in a textbox when used as a value is a string variant data type. To get it to act as a number you would have to use one of the conversion functions like CLng, CInt, CDbl, etc. "Jarle" wrote: To input text i textbox I use: .Shapes("txtbox").TextFrame.Characters.Text = Txtstring 1) If txtstring is a date or number. Can I input as date or number format? (Replace characters.text) 2) If txtstring is i.e. "2". I want to load variable 2 (as number) into variable k. (How to convert "2" (string) to 2(number)). 3) Same as 2 but with dates Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cutting and Pasting Cells into a shape or textbox | Excel Discussion (Misc queries) | |||
| my curser changed from arrow shape to a cross shape???? | New Users to Excel | |||
| Adding shape-type textbox into excel chart sheet | Excel Programming | |||
| Interesting problem with VBA generated textbox (or textframe of shape) length | Excel Programming | |||
| Editting textbox value that is grouped with a shape | Excel Programming | |||
Hybrid Mode
