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