picklepuss
Thread Starter
- Joined
- Mar 25, 2010
- Messages
- 8
I'm sure this is very simple, but since I am self-taught there are tremendous holes in my VBA knowledge.
I have a macro that does several things, including entering a second section on a spreadsheet (so the row location of that section's header will be variable). In the second section header, I need to define a cell for input box data to go into.
What is the best way for me to define a variable cell so that it becomes where the data from the input box (later in the macro) will go?
e.g. (this does not work but shows what I am looking for)
Dim DateCell As Range
ActiveCell = DateCell
**other stuff happens in macro**
Dim Dateinput As Date
Dateinput = InputBox ("What date is it? (m/d/yyyy)")
MyDate = Dateinput
Range("DateCell").Value = MyDate
Thanks for any help!!!
I have a macro that does several things, including entering a second section on a spreadsheet (so the row location of that section's header will be variable). In the second section header, I need to define a cell for input box data to go into.
What is the best way for me to define a variable cell so that it becomes where the data from the input box (later in the macro) will go?
e.g. (this does not work but shows what I am looking for)
Dim DateCell As Range
ActiveCell = DateCell
**other stuff happens in macro**
Dim Dateinput As Date
Dateinput = InputBox ("What date is it? (m/d/yyyy)")
MyDate = Dateinput
Range("DateCell").Value = MyDate
Thanks for any help!!!