Excel userform question

Closed
lmeyer13 Posts 1 Registration date Thursday March 17, 2016 Status Member Last seen March 18, 2016 - Mar 18, 2016 at 02:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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



Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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