[UserForm's Listbox]Why is sheetname empty when using it in another procedure?

Trying to make macro to copy paste data from wb1 to wb2.

Trying to use shtName selection in the list box to use it in another procedure

Please Login or Register  to view this content.

After drilling down, I find shtName variable to be empty.

Please Login or Register  to view this content.

Things that I have tried:

- Putting shtName var in declarations section: Public shtName as worksheet
- Setting shtName to worksheet object using Set keyword.

Is there any other listbox method I should be aware of?

One other question if you could answer:

• How to avoid standard message that states to clear clipboard (at the end of copyData procedure)? Programmatically.

Attachment 763944

________________________________________________

For reference, here is the full code:

Please Login or Register  to view this content.