Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit text length with inputBox
Here is the code I have: Dim csComment As String csComment = InputBox("Please enter your comment." & Chr(10) & Chr(10) & "Comments are not required for No responses") ActiveSheet.Range("l200") = csComment I need to limit the text length to 40 characters or less. This information will eventually be copied into a another workbook that serves as a data sheet for a PivotTable. BTW - I really appreciate all of the help I've recieved here. vb used to really scare me and I stayed way clear of it. Not anymore. I've got much to learn yet, but you guys have really helped me out a lot. Thanks in advance!!! -- BigDave ------------------------------------------------------------------------ BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741 View this thread: http://www.excelforum.com/showthread...hreadid=377905 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit text length with inputBox
Hi BigDave,
This should work Sub LimitMyComment() Dim csComment As String * 40 csComment = Application.InputBox("Please enter your comment." & Chr(10) & _ Chr(10) & "Comments are not required for No responses", Type:=2) ActiveSheet.Range("i200") = csComment End Sub "BigDave" wrote: Here is the code I have: Dim csComment As String csComment = InputBox("Please enter your comment." & Chr(10) & Chr(10) & "Comments are not required for No responses") ActiveSheet.Range("l200") = csComment I need to limit the text length to 40 characters or less. This information will eventually be copied into a another workbook that serves as a data sheet for a PivotTable. BTW - I really appreciate all of the help I've recieved here. vb used to really scare me and I stayed way clear of it. Not anymore. I've got much to learn yet, but you guys have really helped me out a lot. Thanks in advance!!! -- BigDave ------------------------------------------------------------------------ BigDave's Profile: http://www.excelforum.com/member.php...fo&userid=7741 View this thread: http://www.excelforum.com/showthread...hreadid=377905 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limit text length with inputBox
Fan-bloody-tastic!!! Thanks -- BigDav ----------------------------------------------------------------------- BigDave's Profile: http://www.excelforum.com/member.php...nfo&userid=774 View this thread: http://www.excelforum.com/showthread.php?threadid=37790 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
limit text length in a text box in excel 2003 | New Users to Excel | |||
Text length limit | Charts and Charting in Excel | |||
limit text length after importing data | Excel Worksheet Functions | |||
WordBasis insert command -- text length limit | Excel Programming | |||
String length of Inputbox user input. | Excel Programming |