VBA vba #

The solution for “VBA vba #” can be found here. The following code will assist you in solving the problem.

‘UserForm2 module

Private Sub UserForm_Activate()
TextBox1.Text = “Activated”
End Sub

Private Sub UserForm_Deactivate()
TextBox1.Text = “Deactivated”
End Sub

Private Sub CommandButton3_Click()
Me.Hide
UserForm1.Show
End Sub

‘UserForm1 module

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
UserForm2.Show
End Sub’The type-declaration character for Double is the number sign (#),
‘also called HASH

‘Other type declaration characters are:

‘Integer %
‘Long &
‘Currency @
‘Single !
‘Double #
‘String $

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts