User form and concatenated values

[marcusforce]

Hi,

I'm working on a user form where the user is picking a text choice in a combobox(1).
When this is done a counter adds 1 to the variable counterl.

This is where I got a bit stuck:
I want to set a new variable where counterv= combobox1.value AND counterl.value
Then I want to show the counterl value in textbox1.
Help with this bit of coding much appreciated.

 

[stickboy]

Hi,

im not too hot on forms,

but can you now just use code

counterv = combobox1.value & counterl.value

then textbox1.value = counterv

let me know if this works?!!
thanks

 

[marcusforce]

Nope, that seems like the most intuitive solution, but that concatenation doesn't work.

 

[stickboy]

this code works when not in a userform :-

cxan you try replacing "hello" and "hello2" with your counterl.value and combobox1.value ??

by assigning them to variables rather than not trying to concatenate them directly???

have a go

Sub trst()

counter = "hello"
counter2 = "hello2"

counter3 = counter & counter2

MsgBox (counter3)


End Sub

 

[marcusforce]

That was a good piece of advice, works now, thanks!