Adding VBA userform Combobox value to cell on different sheet...

[RJSIGKITS]

Hi Guys.

I know this is extremely remedial to be asking this on here, as I know it is ridiculously easy, but I just can't get it to work!

I have a Userform with a Combobox, and an 'Assign' command button... I simply want the value of the combobox to be added to cell 'F17' on sheet 'Client' when the command button is clicked...

Please put me out of my misery!

 

[gallen]

The only info you missed was the name of the combobox. Place this code in the click event of the Assign button and change the combobox name to whatever you have called it

Sheets("Client").Range("F17") = comboboxName

 

[RJSIGKITS]

Sheets("Client").Range("F17") = comboboxName

[/QUOTE]
Okay, so I genuinely can't see what was different in your line to what I had, but I copy and pasted yours in and it worked!

Thanks for your help!

 

[gallen]

Happy it works. 99% of the time its a simple typo.

 

[RJSIGKITS]

Happy it works. 99% of the time its a simple typo.

Sure, thanks!
I can't stop looking at it though, trying to find what was different!
I felt so stupid asking such a remedial question on here!

 

[gallen]

Out of curiosity, what code did you have?

 

[RJSIGKITS]

I don't know now, as I've pasted yours in place of it!
But that's why I keep looking at it, as I truly can't see what I did differently.. I'm going to write the line below, as I would without looking at yours now:

[COLOR=#333333]Sheets("Client").Range("F17") = cbxassign[/COLOR]

 

[RJSIGKITS]

Yep, and I just used that in my doc, and it works - No idea!

 

[RJSIGKITS]

In future, I'll post the line of code that I'm trying to use in my question, I think - that way, we'll be able to see what I was doing wrong.