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 f...
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.
Thank 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?
- You learn quickly 🙂 Absolutely. Add a Comments column to tblLog. Name the input cell "Comments". Then add to the VBA.
.Range(3) = [Comments]Thank you very much . It's a great help. I'll let you know how I get on
- Thank you so much. A great help