InputBox pops up, but won't display text in worksheet
Posted by Linda on March 20, 2001 4:11 PM
I have a outstanding claims database in Excel that I am trying to update. Once I find the client's name, I want to be able to insert "paid" in the claims status column and the date the claim was paid in a date column.
I finally figured out how to get an InputBox to pop up and prompt me to input the date. I type in a date and click OK. However, nothing displays on my worksheet. I have the date column format set to Date format xx/xx/xx. What am I doing wrong??
Here is my macro:
ActiveCell.FormulaR1C1 = "paid"
Dim Message, Title, MyValue
Message = "Enter Date" ' Set prompt.
Title = "InputBox" ' Set title.
' Display message, and title.
MyValue = InputBox(Message, Title)