Formating copied text from an access column.

I want a user who has selected a form in access and copied it to be able to paste the form with a push of a button into a list. However I don't want the column header to be pasted into the list. Any guidance is welcomed. ~Bryan J. Casler

Is there no VBA guru to help ! :(

Hey Animelion, good to see you again :wave:

Will the 'header' always be present?
Can you post the (copy/paste) code you have so far?


Cheers,

Instead of directly pasting if from the clipboard, you could paste it into a variable and parse out the column header label. Then write it back to the clipboard and the user wont even know whats heppened :)

Well I don't have any code right now. I don't know how to move data from the clipboard to a list box making each new line a new item in the list box. The column header will never be numerical, so All I have to do is check to see if list item one is numerical, if not, then remove it. Thanks for the never ending help, this board has always been my favorite on the net. ~Bryan J. Casler