gd1sum8nfg2
New Member
- Joined
- Aug 30, 2014
- Messages
- 6
hello,
I am trying to paste information, from an input box, in a cell. The cell I want the info in, is in column "P". How my sheet is setup is, when someone enters data into, any row, in column "O", a msgbox pops up saying to enter info into a text box, that will paste info into column "P" next to whatever row, in column "O", the data was originally entered into. I am using an activecell.offset code. The problem is, depending on if the user hits "Enter" or "tab" the active cell will be different. Is there any way to to fix this so the info is always in column "p" next to the cell, in column "O", that the data was entered in?!
Thank you, in advance!
I am trying to paste information, from an input box, in a cell. The cell I want the info in, is in column "P". How my sheet is setup is, when someone enters data into, any row, in column "O", a msgbox pops up saying to enter info into a text box, that will paste info into column "P" next to whatever row, in column "O", the data was originally entered into. I am using an activecell.offset code. The problem is, depending on if the user hits "Enter" or "tab" the active cell will be different. Is there any way to to fix this so the info is always in column "p" next to the cell, in column "O", that the data was entered in?!
Thank you, in advance!