Hi All,
I have an excel spreadsheet that I am using automate data accross to an ms access database. A feature that I have installed is a input box to retrieve a testers comments. The problem is the input box only allows for up to 255 characters, some of the comments I am needing to capture are up to 500 chars. Is there anyway to pull up a form with a textbox on it within excel?
Thanks,
Larry
I have an excel spreadsheet that I am using automate data accross to an ms access database. A feature that I have installed is a input box to retrieve a testers comments. The problem is the input box only allows for up to 255 characters, some of the comments I am needing to capture are up to 500 chars. Is there anyway to pull up a form with a textbox on it within excel?
Code:
Private Sub messagePrompt(rowNum As Integer, colNum As Integer)
Dim Message, Title, Default, MyValue
Default =""
Message = "Please enter comments for this question:" ' Set prompt.
Title = "Tester Comments" ' Set title.
MyValue = InputBox(Message, Title, Default)
End Sub
Thanks,
Larry