| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I have 2 user forms that relate to the same worksheet
Hi & thanks in advance,
I am trying to put 2 user forms that relate to the same worksheet, however its not working... I am getting an error message that says "Compile error: Invalid or unqualified reference" I am extremely new to programming so i would appreciate any help I can get... I can email the "code" through if that helps. -- Thanks, Butterfly Girl |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I have 2 user forms that relate to the same worksheet
hi
why not just post your code here. everyone does it. regards FSt1 "ButterflyGirl" wrote: Hi & thanks in advance, I am trying to put 2 user forms that relate to the same worksheet, however its not working... I am getting an error message that says "Compile error: Invalid or unqualified reference" I am extremely new to programming so i would appreciate any help I can get... I can email the "code" through if that helps. -- Thanks, Butterfly Girl |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I have 2 user forms that relate to the same worksheet
After 2 days of searching I actually found the answer myself!!! :-)
I left the _ (underscore) off the end of the 1st row & obviously this makes a difference as to how the code is handled. Please explain why? But it is now working perfectly. lRow = ws.Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0).Row -- Thanks, Butterfly Girl "FSt1" wrote: hi why not just post your code here. everyone does it. regards FSt1 "ButterflyGirl" wrote: Hi & thanks in advance, I am trying to put 2 user forms that relate to the same worksheet, however its not working... I am getting an error message that says "Compile error: Invalid or unqualified reference" I am extremely new to programming so i would appreciate any help I can get... I can email the "code" through if that helps. -- Thanks, Butterfly Girl |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I have 2 user forms that relate to the same worksheet
It is actually a single line of code.
lRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row _ is used as a line break; incase your code line is lenghty you can use a space and underscore to break that to multiple lines..... If this post helps click Yes --------------- Jacob Skaria "ButterflyGirl" wrote: After 2 days of searching I actually found the answer myself!!! :-) I left the _ (underscore) off the end of the 1st row & obviously this makes a difference as to how the code is handled. Please explain why? But it is now working perfectly. lRow = ws.Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0).Row -- Thanks, Butterfly Girl "FSt1" wrote: hi why not just post your code here. everyone does it. regards FSt1 "ButterflyGirl" wrote: Hi & thanks in advance, I am trying to put 2 user forms that relate to the same worksheet, however its not working... I am getting an error message that says "Compile error: Invalid or unqualified reference" I am extremely new to programming so i would appreciate any help I can get... I can email the "code" through if that helps. -- Thanks, Butterfly Girl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forms? Want floating user-option menu in worksheet. | Excel Programming | |||
| Relate from one worksheet to another | Excel Worksheet Functions | |||
| User forms & worksheet help! | Excel Programming | |||
| Worksheet value to user forms | Excel Programming | |||
| User forms | Excel Programming | |||
Linear Mode
