Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with programming Excel User Forms
Hey all!
I am somewhat new to the world of excel programming, so wanted to get some help from you guys on a problem I am working on. I am trying to create a utility for users which uses multiple worksheets in a workbook and I also have a menu at the start to guide the user to the excel sheet he wants to use. However, I am not too happy with the 'look and feel' of the utility I have developed (for instance, a user has to scroll down within a worksheet to see what all is in there). I feel that I can do this better if I design a userform and have the user form interact with the user. So, specifically, what I want to do is: 1. When the user opens the excel workbook, a user form pops up, and that is the only thing the user sees 2. Based on the options the user selects (different tabs within the same userform) the userform itself pulls out relevant information from different sheets without ever showing that sheet itself Bottom line, I want to be able to avoid direct interaction of the user with the worksheets. I would like the user to be able to interact only with the userform. Is this possible? I hope I am clear enough, most times I can not translate thoughts in my mind clearly! Nikhil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with programming Excel User Forms
Sounds like you'd better off with Access, rather than Excel ......
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with programming Excel User Forms
The spreadsheet metaphor is generally thought to be relatively easy for
people to understand. Your desire to protect users from it is a bit of a mystery to me. Adding a protective userform will be hard work for you and, at best, frustrating for users. I don't know what the problem is with having users 'scroll down' but it may be that adding a summary sheet, with key figures on it, while the underlying data available on detail sheets for those that need it, is an alternative way to go. -- Jim wrote in message oups.com... | Hey all! | | I am somewhat new to the world of excel programming, so wanted to | get some help from you guys on a problem I am working on. I am trying | to create a utility for users which uses multiple worksheets in a | workbook and I also have a menu at the start to guide the user to the | excel sheet he wants to use. However, I am not too happy with the | 'look and feel' of the utility I have developed (for instance, a user | has to scroll down within a worksheet to see what all is in there). I | feel that I can do this better if I design a userform and have the | user form interact with the user. So, specifically, what I want to do | is: | | 1. When the user opens the excel workbook, a user form pops up, and | that is the only thing the user sees | 2. Based on the options the user selects (different tabs within the | same userform) the userform itself pulls out relevant information from | different sheets without ever showing that sheet itself | | Bottom line, I want to be able to avoid direct interaction of the user | with the worksheets. I would like the user to be able to interact only | with the userform. Is this possible? | | I hope I am clear enough, most times I can not translate thoughts in | my mind clearly! | | Nikhil | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with programming Excel User Forms
Hey all,
Thanks for the response. Jim, it's hard for me to put this into words, I wish I could somehow attach a screenshot to my message or something. But I am really not too pleased with the way the excel spreadsheet looks. Along these lines, from what (very little) I know, I guess VBA needs a 'platform' such as excel to work with (I can't have a userform run on its own, without having to open excel). But, isn't there a VB editor that you can use independent of excel? Again, pardon my ignorance, I am still very early into learning VB. Nikhil On Aug 8, 10:27 am, "Jim Rech" wrote: The spreadsheet metaphor is generally thought to be relatively easy for people to understand. Your desire to protect users from it is a bit of a mystery to me. Adding a protective userform will be hard work for you and, at best, frustrating for users. I don't know what the problem is with having users 'scroll down' but it may be that adding a summary sheet, with key figures on it, while the underlying data available on detail sheets for those that need it, is an alternative way to go. -- wrote in message oups.com... | Hey all! | | I am somewhat new to the world of excel programming, so wanted to | get some help from you guys on a problem I am working on. I am trying | to create a utility for users which uses multiple worksheets in a | workbook and I also have a menu at the start to guide the user to the | excel sheet he wants to use. However, I am not too happy with the | 'look and feel' of the utility I have developed (for instance, a user | has to scroll down within a worksheet to see what all is in there). I | feel that I can do this better if I design a userform and have the | user form interact with the user. So, specifically, what I want to do | is: | | 1. When the user opens the excel workbook, a user form pops up, and | that is the only thing the user sees | 2. Based on the options the user selects (different tabs within the | same userform) the userform itself pulls out relevant information from | different sheets without ever showing that sheet itself | | Bottom line, I want to be able to avoid direct interaction of the user | with the worksheets. I would like the user to be able to interact only | with the userform. Is this possible? | | I hope I am clear enough, most times I can not translate thoughts in | my mind clearly! | | Nikhil | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with programming Excel User Forms
But I am really not too pleased with the way the excel spreadsheet looks.
Okay but building an alternative UI that does what you need and does what users need is no small undertaking. 'Beautifying' your worksheet is a lot easier.<g VBA is Visual Basic for Applications and the application in this case is Excel. But there is a standalone Visual Basic that is part of Visual Studio. You could build a windows app with at that pulls data from Excel workbook via ADO (http://support.microsoft.com/kb/257819) but, again, pretty big undertaking. -- Jim wrote in message ups.com... | Hey all, | | Thanks for the response. Jim, it's hard for me to put this into | words, I wish I could somehow attach a screenshot to my message or | something. But I am really not too pleased with the way the excel | spreadsheet looks. | | Along these lines, from what (very little) I know, I guess VBA needs | a 'platform' such as excel to work with (I can't have a userform run | on its own, without having to open excel). But, isn't there a VB | editor that you can use independent of excel? Again, pardon my | ignorance, I am still very early into learning VB. | | Nikhil | | On Aug 8, 10:27 am, "Jim Rech" wrote: | The spreadsheet metaphor is generally thought to be relatively easy for | people to understand. Your desire to protect users from it is a bit of a | mystery to me. Adding a protective userform will be hard work for you and, | at best, frustrating for users. I don't know what the problem is with | having users 'scroll down' but it may be that adding a summary sheet, with | key figures on it, while the underlying data available on detail sheets for | those that need it, is an alternative way to go. | | -- | wrote in message | | oups.com... | | Hey all! | | | | I am somewhat new to the world of excel programming, so wanted to | | get some help from you guys on a problem I am working on. I am trying | | to create a utility for users which uses multiple worksheets in a | | workbook and I also have a menu at the start to guide the user to the | | excel sheet he wants to use. However, I am not too happy with the | | 'look and feel' of the utility I have developed (for instance, a user | | has to scroll down within a worksheet to see what all is in there). I | | feel that I can do this better if I design a userform and have the | | user form interact with the user. So, specifically, what I want to do | | is: | | | | 1. When the user opens the excel workbook, a user form pops up, and | | that is the only thing the user sees | | 2. Based on the options the user selects (different tabs within the | | same userform) the userform itself pulls out relevant information from | | different sheets without ever showing that sheet itself | | | | Bottom line, I want to be able to avoid direct interaction of the user | | with the worksheets. I would like the user to be able to interact only | | with the userform. Is this possible? | | | | I hope I am clear enough, most times I can not translate thoughts in | | my mind clearly! | | | | Nikhil | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Forms - getting them to talk to Excel | Excel Programming | |||
Excel programming window user interface | Excel Programming | |||
User Forms and Excel Functions | Excel Programming | |||
User forms in Excel | Excel Programming | |||
New user in need of assistance excel pop-ups, forms, +more!! | New Users to Excel |