Textbox 2 Value is formula based on Texbox 1

Morning All,

Hope you guys can help me.

I have 2 textboxes, textbox1 and textbox 2 for arguements sake.

what i would like is to put a date in textbox 1.

textbox 2 then calculates the week using this formula:

=TRUNC(Textbox1-Date(Year(Textbox1),1,0)+6))/7)

or something like that anyway how would i go about doing that.

obviously i'd place code into the "textbox1_change" module.

thanks for reading guys!!

Hi,
You did not mention where these textboxs are from so I will assume they are from the controls toolbar

Here's one way,
Place this function into a regular module

Please Login or Register  to view this content.

This code can go into the worksheet module that has the textboxes

Please Login or Register  to view this content.

The code would be very similar if the text boxes are in a UserForm

Cheers both you guys i'll give them a blast, FYI the textboxes are in a userform.