How to get the text box sting value in an excel formula

[bnath]

How to get the text box sting value in an excel formula

 

[SkipVought]

If the question is, "can a SPREADSHEET formula reference a Control Toolbox Textbox?" the answer is no.

Notice that MS Forms has no textbox control.

Hmmmmmmmm.

Skip,

_{[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH!}

 

[Zathras]

bnath, where is the text box? Directly on the worksheet? on a User Form? You haven't given us a lot to work with here.

What exactly is it that you are trying to do?

 

[SkipVought]

You could write a user function like

function TxtValue()
  TxtValue = Textbox1.Text
end function

then in your formula...
[tt]
="Some other stuff"&TxtValue()"more stuff"
[/tt]


Skip,

_{[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH!}