Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this an acceptable way to pop up a form?
i wrote an app for a client. there is a column with account numbers that are
comma separated , for each row of a form. some may have 1 account # , some may have 10. the routines looks at each account # and then populates the form based on their gl account number(s), from an imported text file. so i once the form is populated, i create a before right click event that pops up a form and displays the acct #, acct name and amounts listed in 2 listboxes. anyway, the right click event only fires on single cell in column E and only if the sheet is protected. just wondering if you can foresee any problems i may encounter doing this. -- Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this an acceptable way to pop up a form?
Hi Gary,
Just adding some ... that I've worked with this one : Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _ Cancel As Boolean) Cancel = True If Not UserForm1.Visible Then UserForm1.Show 0 End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If UserForm1.Visible Then UserForm1.Hide End Sub -- Regards, Halim "Gary Keramidas" wrote: i wrote an app for a client. there is a column with account numbers that are comma separated , for each row of a form. some may have 1 account # , some may have 10. the routines looks at each account # and then populates the form based on their gl account number(s), from an imported text file. so i once the form is populated, i create a before right click event that pops up a form and displays the acct #, acct name and amounts listed in 2 listboxes. anyway, the right click event only fires on single cell in column E and only if the sheet is protected. just wondering if you can foresee any problems i may encounter doing this. -- Gary |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this an acceptable way to pop up a form?
thanks for the feedback, halim
-- Gary "Halim" wrote in message ... Hi Gary, Just adding some ... that I've worked with this one : Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _ Cancel As Boolean) Cancel = True If Not UserForm1.Visible Then UserForm1.Show 0 End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If UserForm1.Visible Then UserForm1.Hide End Sub -- Regards, Halim "Gary Keramidas" wrote: i wrote an app for a client. there is a column with account numbers that are comma separated , for each row of a form. some may have 1 account # , some may have 10. the routines looks at each account # and then populates the form based on their gl account number(s), from an imported text file. so i once the form is populated, i create a before right click event that pops up a form and displays the acct #, acct name and amounts listed in 2 listboxes. anyway, the right click event only fires on single cell in column E and only if the sheet is protected. just wondering if you can foresee any problems i may encounter doing this. -- Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In a formula, how do I set a maximum acceptable value? | Excel Worksheet Functions | |||
blank cells in a formula gives me an answer not acceptable to prin | New Users to Excel | |||
Pass variable from form to form to form | Excel Programming | |||
Strange issue freezing parent form when unloading a child form | Excel Programming | |||
Conditional Formatting formula not acceptable? | Excel Discussion (Misc queries) |