Forum Discussion
Solved
Sending text
Good afternoon
Can someone please help?
I would like to send text from one cell to another based on the name and date matching .
So I have
one cell showing today's date
One cell with a list function showing names
A blank text box
I would like to be able to write text on the move and save it to a cell which is in a table matching the date and name .
I hope that makes sense lol
Attached is a workbook. It has a data entry area like the first picture. The "Name" field has a dropdown from data validation that is tied to tblNames. When someone clicks "Post", whatever is in the Date and Name Fields is posted to tblLog.
The picture at bottom is the code. Used Alt-F11 to go from Excel to VBA and back again.
Hope this helps.
ooops! In the VBA window is Dim oLo as ListObject. That is totally unnecessary.
- This sounds like a data entry problem.
Excel's formulas cannot "Send" values to cells. Excel's VBA can. Do you want to use VBA?
Alternatively, you may want to consider Excel's automatic user form: https://www.easyexcelanswers.com/form.htmlThank you for replying.
- Yes I can use a vba.
- How would I do that.
- I wasn't sure if I could do some like if name cell and date cell then A1=B1 for instance
Thank you .
I will try it when I'm at work tomorrow.
Could I add a range 3 and title it
Ie comments and have a blank box where I can add the text and it will save that?
