VBA to set value and tab off of text box

[bbatson]

Hello,

Suppose I had a text box, call it "textbox". What would be the code to set the value of this textbox to a certain number, say 7, and then tab off of the text box onto the next item in the tab order?

Thank you!

[mshmyob]

Try

[CODE=vb]
Me.textbox.SetF ocus
Me.textbox.Valu e = "7"
SendKeys "{TAB}", True
[/CODE]

Hello,

Suppose I had a text box, call it "textbox". What would be the code to set the value of this textbox to a certain number, say 7, and then tab off of the text box onto the next item in the tab order?

Thank you!

[missinglinq]

SendKeys is a bad idea and should be avoided unless nothing else will work! It's unpredictable and can cause strange things with NumLock! Why not simply set the focus to the next textbox in line? Instead of

SendKeys "(Tab)", True

try

NextTextBox.Set Focus

Linq ;0)>

[mshmyob]

I agree Linq but he wanted to TAB. I just assumed by his request he didn't know what his next control would be (lol).

SendKeys is a bad idea and should be avoided unless nothing else will work! It's unpredictable and can cause strange things with NumLock! Why not simply set the focus to the next textbox in line? Instead of

SendKeys "(Tab)", True

try

NextTextBox.Set Focus

Linq ;0)>