i hv created userform in Excel VBA in which textboxes and other such objects are made. Now I want to copy data from excel sheets to userform manually by copy-paste shortcut keys. Problem is when userform is active, all the workbooks are then deactivated until it is open.
I want both the workbook and as well as userform to be active, so that I can copy-paste my excel sheets data to userform.
Plz solve this at ur earliest.