| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make values of spreadsheet show in a modeless forms text bo
I have a Form that i display in Modeless state to allow the user make
selections and changes to spreadsheets without closing the form. I would like to have the activecell value of the spreadsheet show up in a textbox on the form. i have TWO questions: 1) I am using the personal.xls file for all the forms and macros to make it available to all workbooks, will the Workbook_SheetSelectionChange of personal.xls fire for the activeworkbook AND 2) Is there a way to indiacte that the modeless form is loaded and showing to captuer the event only if it is showing at the time? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I make excell show time values greater than 24 hrs? | Excel Worksheet Functions | |||
| make Pivot table show only available values in dropdowns | Excel Discussion (Misc queries) | |||
| create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
| I need to have only the values show in a spreadsheet. | Excel Worksheet Functions | |||
| Hide/Show modeless userform when activating/deactivating workbooks | Excel Programming | |||
Threaded Mode
