UserForm

[vwsteven]

Hello all,

I'm writing a code for a UserForm in Excel VBA.
What I want to do is when I type a date in one of the fields, the date -2 days appears in another text box.

is that possible or can you only input data in these fields?

thanks for any help

 

[doofusboy]

Do you mean if you type a date into TextBox1 on the form that TextBox2 will show that date minus 2 days? If so, the following should work for you.

Private Sub TextBox1_AfterUpdate()
    TextBox2.Text = CDate(TextBox1.Text) - 2
End Sub

 

[vwsteven]

Hey.

yea that's what I mean.
Unfortunatly that doesn't work.

Do you have any other ideas?

Thanks

 

[doofusboy]

I tested it on a user form that has 2 text boxes and it works just fine for me. What error(s) are you getting? Are you using 2 text boxes on a user form?

 

[vwsteven]

hey

i'm not actually getting an error or anything
it just doesn't seem to work. I have two columns of text boxes and I want to enter the dates in the one and then see them in the other. but if they are in a weekend for example, I have to be able to amend them manually.

thanks for your help