Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating Execl Form, etc
Hi all,
I would like to perform a function that I think is not impossible, but may be unusual. In my workbook I have 3 worksheets, I would like to have a small 'floating' form that keeps track of information as it is entered into the various worksheets. The form would keep constant total of other totals as they change on the individual sheets while floating and always staying on top the current sheet while data entry happens. Question is, how to do it? Thanks for the ideas! -lumpjaw |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating Execl Form, etc
Check the help for the .Show method of the userform and see the difference
between vbModal and vbModeless. NickHK "Lumpjaw" wrote in message ... Hi all, I would like to perform a function that I think is not impossible, but may be unusual. In my workbook I have 3 worksheets, I would like to have a small 'floating' form that keeps track of information as it is entered into the various worksheets. The form would keep constant total of other totals as they change on the individual sheets while floating and always staying on top the current sheet while data entry happens. Question is, how to do it? Thanks for the ideas! -lumpjaw |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Floating Execl Form, etc
thanks.
"NickHK" wrote in message ... Check the help for the .Show method of the userform and see the difference between vbModal and vbModeless. NickHK "Lumpjaw" wrote in message ... Hi all, I would like to perform a function that I think is not impossible, but may be unusual. In my workbook I have 3 worksheets, I would like to have a small 'floating' form that keeps track of information as it is entered into the various worksheets. The form would keep constant total of other totals as they change on the individual sheets while floating and always staying on top the current sheet while data entry happens. Question is, how to do it? Thanks for the ideas! -lumpjaw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Starting a 'floating' form once a spreadsheet is open | Excel Programming | |||
Floating toolbar and floating comment? | Excel Programming | |||
EXECL | Setting up and Configuration of Excel | |||
Floating Form | Excel Programming | |||
Data Input Execl Form | Excel Programming |