So I want to have the form take the data I enter and place it on a certain line that i assign to it.
So if I have a box on the form that I can enter a 9 for instance, it will enter that data from the form on line 9 on the sheet.
If I enter aa 3, it will enter it into line 3 on the sheet, and so on.
I can not use a macro, IT guys wont allow macros, but the VBA works good.
VBA is the language macros are written in.Originally Posted by DanPort
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
far easier to give in-context solution if you upload your workbook - see big yellow banner - how to.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks