Forum Discussion
Sending text
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
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.
- Hello mate just wanted to check before I start.
Do i add a button the assign your post click macro to it and with your ranges you have them on your work sheet horizontally in separate columns. Can I put them vertically( does it go by the name of the cell or by the column)
Thanks again- The inputs go by name so place them anywhere you like.
The log table can be placed anywhere as well, but it is a table so it will always go down the page.
The "Post" button is assigned to the macro. You can modify the macro and the button will still work. Place the button anywhere you like.
Hope that helps.- Thanks all works perfectly on the computer but didn't realise vba doesn't work on android. Do you know how to covert it to office, js