use VBA to put text into a text box...

[sunilmulay]

Hi there

is there a way to use VBA to insert text into text box? I don't believe it is possible to put a formula into a text box (I have posted a question on the Excel general forum to check this), so my next thought is: can I use VBA to insert the values I want instead?

Basically, I have a text box which I want to display certain text based on certain criteria.

Thanks in advance
Sunil

[D_Rennie]

Hello,

You may be able to do this a few diffrent ways.
to update a sheet textbox from VBA.

Please Login or Register  to view this content.

Though if you aready have a formular that will display the resutls that you want you can reference this cell in the sheet textbox.
E.g
(A1) = 1
(A2) = 3
(A3) =A1+A2.... 4
Textbox1 formular =A3
this would show whatever A3 is.

Hope this helps

[sunilmulay]

that's great news ! I didn't thing that was possible.... Thanks!

Just so I understand the part regarding the formula...yes, I do have a formula, already calculating the result I want to put in the text box. so where do I put the line:

Textbox1 formula =A3

Thanks
Sunil

[D_Rennie]

Im asumming that this is a sheet textbox.
Select the textbox in the formular bar it should show somehitnk like =EMBED("Forms.TextBox.1","") change this to =A3

[sunilmulay]

got it!
Thanks a bunch!
Sunil