Textbox - Shape

  • Thread starter Thread starter Jarle
  • Start date Start date
J

Jarle

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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top