Need cmd to trim the end of text in a textbox

[Leweez]

Hi all, I made a command button to paste some copied text from a worksheet1 to a userform textbox in another worksheet2.

Here's my simple code:

Private Sub CommandButton1_Click()
TxtBoxProduct.Paste
End Sub

It works fine but I always have to get to the end of the textbox text after that in order to remove any blank spaces as it destroys my worksheet2 format (i.e. borders etc).

Is there a "trim" function I could add to my code?
As you can see, I'm kinda new with vba...

Many thanks in advance for your help!
Regards
Leweez

[kalbasiatka]

Hi. Show an example.

[Leweez]

What can I show as an example?

[kalbasiatka]

for example, the file with your comboboxes

[Leweez]

It's not a combobox, it's a plain Textbox.

[kalbasiatka]

what difference, the main thing is to see what happens

[Leweez]

I don't know what to show you but this is what I want to do:

1- I Copy plain text from a worksheet
2- I want to paste this text into another worksheet in a userform textbox.
3- It actually does copy perfecty the text but for some unknown reason, it must have some "blank spaces" while pasting the text because it messes up the formatting of my worksheet2.

4- If I go at the end of my "pasted" text before closing my userform and do a "delete", then the formatting of worksheet2 is Ok.

I would want to avoid doing this last step as it is not very practical.

[kalbasiatka]

became not clearer but here is the code with "trim"

Please Login or Register  to view this content.

[Leweez]

Unfortunately, it doesn't work. My paste text is still messing with the format of my "receiving" worksheet.
Sorry that I cannot make my question more clearer.

Is there a better way to have the mouse click contextmenu to "cut/copy/paste" in a vba userform ?

[Norie]

Leweez

Do you actually have a userform with a textbox or are you referring to a textbox on a worksheet?

If it's the latter is it a textbox from the Forms or ActiveX toolbar?

Also, are you just trying to get the value from a worksheet into a textbox?

To do that you don't need to paste.

kalbasiatka

Why not use VBA's Trim?

[kalbasiatka]

Why not use VBA's Trim?

vba trim removes only the last spaces

[Leweez]

As I mentionned in my post, I have a userform with several textbox that places everything from that userform to the worksheet.
I try to copy/paste some text from another worksheet in that userform textbox but it's not working.

How can we right click on a userform and have a context menu?

[kalbasiatka]

here is an example with a form

[Norie]

Leweez

If you want to put the value from a cell in a textbox why paste?

Please Login or Register  to view this content.

Vice versa, textbox to sheet.

Please Login or Register  to view this content.

kalbasiatka

VBA Trim removes trailing and leading spaces.

The worksheet function TRIM removes trailing/leading spaces and replaces multiple spaces between text with single spaces.

[Leweez]

[QUOTE=Norie;4339780]Leweez

If you want to put the value from a cell in a textbox why paste?

Please Login or Register  to view this content.

Vice versa, textbox to sheet.

Please Login or Register  to view this content.

Because the value of a cell comes from another workbook and I have to copy/paste several cells to my userform textbox located in another workbook.
My error here, I wrote "2 different worksheets" but it's really 2 different workbook.

[Norie]

It doesn't matter, just include reference(s) to the relevant workbook(s) as well as the worksheet(s) in the code I posted.

For example.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Leweez]

Thank you!

Regards
Leweez