Running Standard Module Code from Dataform

J

Jim May

From a command button on a dataform the "on click" event,
can I run code from a Standard module?

Totally, separate Q:
In a standard module
where I use
Dim LrowS2 as Integer
and later in the code I have a line:
LrowS2 = Range("B65356").end(xlUp).row

I get compile error at this point, with explanation of:
Statement Invalid outside Type Block..
???? Not a clue here....
 
T

Tom Ogilvy

If you mean userform, no. You can call the procedure in the general module
from the click event of the button.

the line of code works fine, so it must have something to do with the
context of the statement.

Not a factor, but
You might declare LrowS2 as long as you gain nothing by declaring it as
Integer and Integer can not hold a number as large as 65536 (and you have
65356).
 

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

Top