how to pass a label as an argument

**dmcgov** · 07-23-2020, 07:31 AM

so i have this code for label 1 that i would like to stream line but getting run time error 13 type mismatch

Please Login or Register  to view this content.

and here is the sub:

Please Login or Register  to view this content.

when i type in the immediate window the following:

Please Login or Register  to view this content.

label question.png

i get a "Label" which seems right but when i pass that in the labelclick, it returns the caption of the label and not the label number. what am i doing wrong?

label caption not label number.jpg

**torachan** · 07-23-2020, 07:41 AM

Try

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**Richard Buttrey** · 07-23-2020, 07:44 AM

A Copy of the workbook would help.

Perhaps you need the TabIndex property?

**dmcgov** · 07-23-2020, 07:50 AM

richard, i just added the file.

torachan, not sure those will work as the sub's argument is for a label number but i will try.

**dmcgov** · 07-23-2020, 07:53 AM

torachan, tried but did not work. what i want returned is the label number as that is needed in the sub CallLblClk. how can i make that work?

**dmcgov** · 07-23-2020, 08:45 AM

so fixed it (yay) by doing the following in the sub header:

Please Login or Register  to view this content.

now this works for click event 1:

Please Login or Register  to view this content.

**torachan** · 07-23-2020, 09:37 AM

Too late now to solve your problem.
I knew in the back of my mind I had similar problems passing variables from UserForm to a print routine in a module.
My trouble is with advancing years I have forgotten more than I have learned and have to trawl through my archives.
In that particular instance I did not want to declare global variables, so declared the same variable in the UserForm and Module.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

how to pass a label as an argument

LinkBack

Thread Tools

Rate This Thread

Display

how to pass a label as an argument

Re: how to pass a label as an argument

Re: how to pass a label as an argument

Re: how to pass a label as an argument

Re: how to pass a label as an argument

Re: how to pass a label as an argument

Re: how to pass a label as an argument

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Pass Sheet name as argument to function

VBA Argument pass to DLL Issue

pass control as argument

Pass argument to SetSourceData

[SOLVED] Pass function as argument to UDF

Pass Argument?

Bookmarks

Bookmarks

Posting Permissions