Previous Topic Next Topic

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 Contributor 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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Nero 6 serial number
Yoseph12 -
Ambucias -

1 response