matty25
11-05-2008, 02:55 PM
I have the vba code to which enables me to copy text from several textboxes to the clipboard. The textboxes (1-7) are:
Company Name (TextBox 1)
Add Line 1
Add Line 2
Add Line 3
City
County
Post Code (TextBox 7)
The button works fine and copies the text from the textboxes to the clipboard so that i can use it in other programs eg. word.
I have now discovered that there isnt always a Address Line 3 and sometimes this box can be left blank.
Is there any code available to say if any of the textboxes (1-7) is blank or doesn't contain anything/any text, then not to include it in the copy function? So that when i paste it into word it only pastes the textboxes which have been filled in.
Many thanks, Matt
Company Name (TextBox 1)
Add Line 1
Add Line 2
Add Line 3
City
County
Post Code (TextBox 7)
The button works fine and copies the text from the textboxes to the clipboard so that i can use it in other programs eg. word.
I have now discovered that there isnt always a Address Line 3 and sometimes this box can be left blank.
Is there any code available to say if any of the textboxes (1-7) is blank or doesn't contain anything/any text, then not to include it in the copy function? So that when i paste it into word it only pastes the textboxes which have been filled in.
Many thanks, Matt