Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Ricky Johnson on Dec 25 In MS Office Category.

direct input in cell

Question Answered By: Kara Hicks 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.

This Question has 3 more answer(s). View Complete Question Thread

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

Related Topics:

Copying current cell's value to another cell
re-directing pivotcache based on user input
input at active cell like inputbox
Moving data in the last cell of row to another column cell
Action taken by Excel when a condition causes a cell's value
Function needed to split the content of a cell intomany cells
Function needed to split the content of a cell into many cells
Finding and replacing the cell next to a cell with a certain string
Copy Value produced by formula in cell C3 to cell D3
how are cell coordinates referenced on a clicked cell
to see if text in a cell in a column is contained in any cell
Update a cell based on a DDE updated cell value
active cell no longer advances to cell below
A Paragraphs in one cells --> convert into a line in per cells
Cell validation based on the contents of previous cell
Copy cell contents to same cell on different worksheet if contains
How to copy automaticly (..using VB) my active cell after cell entry in different cell in anoth
Add-Ins loaded into Excel
Array to array direct transfer in VB
file direct printing

Tagged:direct input in cell

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us