<div>
Just add module and create a public variable there<br />
<br />
<br />
set the variable when your second form unload<br />
<br />
ie<br />
<br />
Private Sub UserForm_QueryClose(Cancel<wbr /> As Integer, CloseMode As Integer)<br />
<br />
<br />
d = &quot;your date form string&quot;<br />
End Sub
</div>


Just add module and create a public variable there


set the variable when your second form unload

ie

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)


d = "your date form string"
End Sub

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have 2 userforms in an excel macro, in the first one there is a text field and button near it. when the button is pressed, a second userform opens. On the second userform, there is the calander control with an ok button. when a date is selected, and the ok butotn is pressed, I want the second userform to be dismissed, and the date entered into the text field on the first userform with the format dd/mm/yyyy - not including the hours and mins. or whatever goes by default. I also need to reference that date inside the macro in another function within the first userform.<br />
can someone explain how variables are passed along in vba?<br />
<br />
thanks in advance
</div>
</div>


Hi,

I have 2 userforms in an excel macro, in the first one there is a text field and button near it. when the button is pressed, a second userform opens. On the second userform, there is the calander control with an ok button. when a date is selected, and the ok butotn is pressed, I want the second userform to be dismissed, and the date entered into the text field on the first userform with the format dd/mm/yyyy - not including the hours and mins. or whatever goes by default. I also need to reference that date inside the macro in another function within the first userform.
can someone explain how variables are passed along in vba?

thanks in advance

passing data from one userform to another

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.