Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
String length of Inputbox user input.
Hi,
I want to return the string length of the input a user gives in an inputbox in VBE. Any suggestions? Hersh. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
String length of Inputbox user input.
Hi Hersh
Sub test() Dim S As String S = InputBox("Say what") MsgBox Len(S) & " characters" End Sub Length 0 means no message or "Cancel", very useful to trap that event. -- HTH. Best wishes Harald Excel MVP Followup to newsgroup only please. "Hersh" wrote in message ... Hi, I want to return the string length of the input a user gives in an inputbox in VBE. Any suggestions? Hersh. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
String length of Inputbox user input.
dim TheLenght as Long
TheLenght= Len(Inputbox()) Wendel "Hersh" skrev i meddelandet ... Hi, I want to return the string length of the input a user gives in an inputbox in VBE. Any suggestions? Hersh. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero-Length string vs Zero (also a valid value) | Excel Worksheet Functions | |||
Finding a string of unknown length in a string of unknown length, Help! | Excel Discussion (Misc queries) | |||
String length | Excel Discussion (Misc queries) | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel |