MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

direct input in cell

  Asked By: Ricky    Date: Dec 25    Category: MS Office    Views: 1577

with inputbox i can enter data to cell but in new window, can i input data
direct to cell with vba?



4 Answers Found

Answer #1    Answered By: Kara Hicks     Answered On: Dec 25

Yes, I do quite often.
ActiveCell.FormulaR1C1 = strMonth & "/" & strDay & "/" & strYear

Will concatenate date values with the / to provide a converted date.

ActiveCell.Offset(1, 0).Range("A1").Select 'Moves the cursor down to
the next row.

Answer #2    Answered By: Jens Brown     Answered On: Dec 25

ActiveCell.Offset(1, 0).Range("A1").Select 'Moves the cursor down to

what is funtion Range("A1") ? i try without Range("A1") its run ok.

Answer #3    Answered By: Darrel Nelson     Answered On: Dec 25

You are correct, the Range("A1") is redundant.

Answer #4    Answered By: Jake Evans     Answered On: Dec 25

Yes. Just create a Range reference that points at the cell  - e.g. Range("A5")
and set its Value or Formula property to whatever you want to put in the cell.

Didn't find what you were looking for? Find more on direct input in cell Or get search suggestion and latest updates.