Cant transfer variable using Public declaration

[Dan Vollmer]

I am trying to transfer a date from a User Form subroutine to a worksheet subroutine but cant seem to make it work. I have attached the workbook, the section of code I am having trouble with is in the userform and the PT Monthly Report-1 worksheet. The variable name is BSDT. I want it to be a date. Thanks.

Dan

[Norie]

Dan

Since you've declared BSDT in the userform module it isn't actually public.

Public variables need to be declared in a standard module.

Where/when are you trying to use BSDT, or more importantly the data selected, anyway?

By the way, you could actually access the selected date elsewhere in the code just by using BillingDateTB.Text.

That would only work if the userform was loaded of course, which it still will be after you've hidden it.

[Dan Vollmer]

Hi Norie, thanks for your help.

Would my worksheet SelectionChange be considered a standard module that I could declare a public variable?

I tried to use BillingDateTB.Text to transfer the date to my 'PT Monthly Report-1' but I kept getting errors so I tried to use BSDT but I would prefer the first method. Do you have any suggestions?

Thanks

Dan

[Norie]

Dan

A 'standard'q module is one created via Insert>Module.

I actually missed out an important part in how to refer directly to the value on the form.

For that to work you need to precede the control name with a reference to the userfom.

For example, UserForm1.BillingDateTB.Value.

You'll also need to convert the value to get a 'real' date, just as you are doing in the current code.

By the way, it's usually better to refer to a value directly rather than using a public variable.

[Dan Vollmer]

How do I let the board know that the problem is SOLVED. Not sure how to do it.

Dan

[Norie]

Select Thread Tools from the menu link above and mark this thread as SOLVED.

PS How was it solved?

[Dan Vollmer]

I transferred the data using UserForm1.BillingDateTB.Value variable. It worked well. When I was first try to use it I forgot to put the UserForm in front of the variable. Thanks Again!

Dan

[Norie]

Dan

You never forgot the userform name, it was really me.