Excel userform question

Closed
lmeyer13
Posts
2
Registration date
Thursday March 17, 2016
Status
Member
Last seen
March 18, 2016
- Mar 18, 2016 at 02:03 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Mar 22, 2016 at 01:03 PM
Hello,

I have spreadsheet with a button on it that opens a userform. This userform will populate data to the same sheet the button is on. How do I get this data to populate to a different sheet in the same workbook?

Thanks in advance for your input.

Lisa



1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
Mar 22, 2016 at 01:03 PM
Hi Lisa,

Try putting the sheet name in front of the cell reference as in:
Sheets("YourSheetName").

Best regards,
Trowa
0