Textbox and string

[joacro]

Hi there,

Hope someone can help me with this query

I have a textbox with I need to mix with other string
if an option is selected say optafr
ex
My name is "textbox value"

How do I get to do this in excel vba

Thanks in advance

 

[VoG]

Hi

Maybe

MyString="My name is " & TextBox1.Text

 

[joacro]

Hi

Maybe

MyString="My name is " & TextBox1.Text

VoG
Thank you for your reply. I need the above to go into a specific range
("A1:A2")

 

[VoG]

Try

Range("A1").Value = "My name is "
Range("A2").Value = TextBox1.Text

 

[joacro]

Hi there Peter,

I got it

Range("A1:C1").Value = "My name is " & TextBox1.Text

 

[Rasm]

if optafr.value then 'So only if the option burron is clicked

end if

 

[VoG]

if optafr.value then 'So only if the option burron is clicked

end if

I don't know what you are on but I'd love some. Oblivion here we come

 

[Rasm]

He has an option button called 'optafr' - only want to combine if it is true - at least that is how I read the original post - but maybe not.