Textbox Default Value

[mharper90]

I'm trying to have a textbox default value work similar to a formula.

I'm using

Me.TextBox2.Value =

And I want the value to be ws1.Range(C4) + 1, and if that is >4, then I want the value to be 1. (C4 displays the current quarter, and I want the texbox to default to the next sequential quarter)

Thanks!

 

[Trebor76]

Hi mharper90,

Try this:

If ws1.Range("C4") + 1 > 4 Then
    Me.TextBox2.Value = 1
Else
    Me.TextBox2.Value = ws1.Range("C4")
End If

Hope that helps,

Robert