control default value

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

When writing functions with optional input values, if nothing is specified
for a long integer, for example, the default value is 0. What is the default
value if the input variable is a control or form?

THanks,
Sam
 
Sam said:
When writing functions with optional input values, if nothing is specified
for a long integer, for example, the default value is 0. What is the default
value if the input variable is a control or form?
Click to expand...


Unspecified optional object arguments are Nothing. You can
check for the situation using the Is operator:

If objectarg Is Nothing Then
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate Form Name to Parse for function 1
change control property 2
BeforeUpdate and KeyDown 2
Click on website button with tag "button" 0
Frontpage 2000 - Going to a new page from a value in a drop-down box 0
VBA code to select website drop down opion 0
Default date 2
Re: How can I read CSV file using VBA? 5

Back
Top