Hi,

with my worksheet open, I want to pop up a non-modal dialog box such that
when I click within the worksheet the dialog stays on top anyways (the click
changing focus to the worksheet but leaving the dialog visible on top); in
the worksheet there are simply rows of integers and the user will only click
the row headers to select an entire row at a time; now, what I want in the
dialog box to appear is the sum (or whatever, it doesn't matter for now) of
the number in the rows that are selected, that is - the user clicks once =
the dialog shows the number in the row clicked; the user Ctrl+clicks in
another row = the dialog box shows the sum of the numbers in both rows; the
user Ctrl+clicks one of the rows selected = the dialog box adjusts the sum
appropriately, ie subtracts from the sum the number in the row just
unselected;...
Is there a piece of code to show me how to create such dialog box and how to
have it 'track' such dynamically changing selection? Thank you!!!

On Apr 24, 6:37*am, Mac wrote:
Hi,

with my worksheet open, I want to pop up a non-modal dialog box such that
when I click within the worksheet the dialog stays on top anyways *(the click
changing focus to the worksheet but leaving the dialog visible on top); in
the worksheet there are simply rows of integers and the user will only click
the row headers to select an entire row at a time; now, what I want in the
dialog box to appear is the sum (or whatever, it doesn't matter for now) of
the number in the rows that are selected, that is - the user clicks once =
the dialog shows the number in the row clicked; the user Ctrl+clicks in
another row = the dialog box shows the sum of the numbers in both rows; the
user Ctrl+clicks one of the rows selected = the dialog box adjusts the sum
appropriately, ie subtracts from the sum the number in the row just
unselected;...
Is there a piece of code to show me how to create such dialog box and how to
have it 'track' such dynamically changing selection? Thank you!!!

There is a really cool trick that excel does. Down in the bottom
right corner of excel it will say saomthing like Num. Right click in
this area and you can have it sum your selection or average and other
functions. Is this what you are looking to accomplish?
Jay

If only it were that simple ...:-D I need to do further processing on the
data in the selected rows; all I need is to somehow display this
stay-where-you-are sort of a 'dialog' and a way to to read that dynamically
changing selection as the user goes on clicking ...

"jlclyde" wrote:

On Apr 24, 6:37 am, Mac wrote:
Hi,

with my worksheet open, I want to pop up a non-modal dialog box such that
when I click within the worksheet the dialog stays on top anyways (the click
changing focus to the worksheet but leaving the dialog visible on top); in
the worksheet there are simply rows of integers and the user will only click
the row headers to select an entire row at a time; now, what I want in the
dialog box to appear is the sum (or whatever, it doesn't matter for now) of
the number in the rows that are selected, that is - the user clicks once =
the dialog shows the number in the row clicked; the user Ctrl+clicks in
another row = the dialog box shows the sum of the numbers in both rows; the
user Ctrl+clicks one of the rows selected = the dialog box adjusts the sum
appropriately, ie subtracts from the sum the number in the row just
unselected;...
Is there a piece of code to show me how to create such dialog box and how to
have it 'track' such dynamically changing selection? Thank you!!!

There is a really cool trick that excel does. Down in the bottom
right corner of excel it will say saomthing like Num. Right click in
this area and you can have it sum your selection or average and other
functions. Is this what you are looking to accomplish?
Jay

On Apr 24, 8:26*am, Mac wrote:
If only it were that simple ...:-D I need to do further processing on the
data in the selected rows; all I need is to somehow display this
stay-where-you-are sort of a 'dialog' and a way to to read that dynamically
changing selection as the user goes on clicking ...



"jlclyde" wrote:
On Apr 24, 6:37 am, Mac wrote:
Hi,

with my worksheet open, I want to pop up a non-modal dialog box such that
when I click within the worksheet the dialog stays on top anyways *(the click
changing focus to the worksheet but leaving the dialog visible on top); in
the worksheet there are simply rows of integers and the user will only click
the row headers to select an entire row at a time; now, what I want in the
dialog box to appear is the sum (or whatever, it doesn't matter for now) of
the number in the rows that are selected, that is - the user clicks once =
the dialog shows the number in the row clicked; the user Ctrl+clicks in
another row = the dialog box shows the sum of the numbers in both rows; the
user Ctrl+clicks one of the rows selected = the dialog box adjusts the sum
appropriately, ie subtracts from the sum the number in the row just
unselected;...
Is there a piece of code to show me how to create such dialog box and how to
have it 'track' such dynamically changing selection? Thank you!!!

There is a really cool trick that excel does. *Down in the bottom
right corner of excel it will say saomthing like Num. *Right click in
this area and you can have it sum your selection or average and other
functions. *Is this what you are looking to accomplish?
Jay- Hide quoted text -

- Show quoted text -

Mac,
You shoudl try what I suggested. Right click and change it to sum.
Now everythign that you ahve highlighted will be summed in this box.
If you want to do this VIA code, I am not sure how you woudl get a
object to float around and show you the sum. If you wanted it in a
specific cell or group of cells you coudl do a change event procedure
or something.
Jay

Simply a user form with the Showmodal proerty set to false is exactly what I
need.:-)

"Mac" wrote:

Hi,

with my worksheet open, I want to pop up a non-modal dialog box such that
when I click within the worksheet the dialog stays on top anyways (the click
changing focus to the worksheet but leaving the dialog visible on top); in
the worksheet there are simply rows of integers and the user will only click
the row headers to select an entire row at a time; now, what I want in the
dialog box to appear is the sum (or whatever, it doesn't matter for now) of
the number in the rows that are selected, that is - the user clicks once =
the dialog shows the number in the row clicked; the user Ctrl+clicks in
another row = the dialog box shows the sum of the numbers in both rows; the
user Ctrl+clicks one of the rows selected = the dialog box adjusts the sum
appropriately, ie subtracts from the sum the number in the row just
unselected;...
Is there a piece of code to show me how to create such dialog box and how to
have it 'track' such dynamically changing selection? Thank you!!!