Printable View
hello agin!
god i hate VBA ...
can some one help i can seem to setfocus to a text box, i have made sure its visible and NOT locked bvut a get a run time error 2110:confused:
i tried looking up that error but can find it!
this is driving me nuts
my goal is to call a sub which i have to pass in 2 textboxes
when this sub is called the first time it runs fine but on the next call it dies...... pls someone HELP
Maybe this is a stupid answer but i can not completely place your problem.
If you set the focus because you want to get out a value of the textbox with the .text property, this might be a solution.
Use the .value instead of the .text property in VBA, this way you do not have to set the focus to the control to get out the content.
Greetings,
sorry let me explain myself a bit more..
i have a text box in which users type in chars.
when the textbox loses its focus my sub is called
the sub requires the text box the user was typing into and an error textbox
my sub does some calculation and then puts its answer into this error box
OK... the problem is that i have 11 of these text boxes which i need to check and when dones manually ie the user types in .... and then presses TAB and it loses focus everything is fine
my problem is that i have another field, and if this changes a need to recalculate all the textboxes!!
i have tried calling them individually but only the first one will calcualte and the otjhers will not...
does this makew any sence??
PLs help as this is driving me NUTS!