Debraj
Excel Ninja
Hi,
I have list of data in a sheet.
How to copy some text in clipboard using VBA.
I have created a SQL query i.e select ... where EmpCode in ('list of unique data using VBA and concat')...
Everything is going smoothly, but i am unable to copy the msg (a rally BIG String Variable) to the Clipboard, so that user dont have to select the textbox, and then CTRL+A , and then hit CTRL+C.
just hit the COPY button, and textbox1.text will goes to clipboard and me.unload..
Please Help
I have list of data in a sheet.
How to copy some text in clipboard using VBA.
I have created a SQL query i.e select ... where EmpCode in ('list of unique data using VBA and concat')...
Everything is going smoothly, but i am unable to copy the msg (a rally BIG String Variable) to the Clipboard, so that user dont have to select the textbox, and then CTRL+A , and then hit CTRL+C.
just hit the COPY button, and textbox1.text will goes to clipboard and me.unload..
Please Help