Hi,
I'm using an InputBox to obtain a number, however it records it as text (e.g. "5.5") instead of a number (5.5).
How do I convert the text (inside the macro) to a number?
Thanks
Paul
Hi,
I'm using an InputBox to obtain a number, however it records it as text (e.g. "5.5") instead of a number (5.5).
How do I convert the text (inside the macro) to a number?
Thanks
Paul
Possibly...Please Login or Register to view this content.
Seems to do the trick. Thanks.
Use InputBox Function instead
e.g
Please Login or Register to view this content.
Works also. Thanks.
Is there a way to get a Title on the InputBox, rather than just Ïnput"?
Please Login or Register to view this content.
Ben Van Johnson
You will find all the protocols like Default value.
https://docs.microsoft.com/en-us/off...ation.inputbox
Thanks. Also works just fine
You are welcome and thanks for the rep.
When you want to limit the data type of return value, InputBox function is a better option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks