Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a user interface in VBA
hi, i'm trying to create an interface that works with excel in the
background. I'm looking to do this in VBA but i'm not exactly sure how to go about doing this. I want to create a form which takes some information from the user and based on this information, it goes back to an excel spreadsheet and a graph or some sort of plot is created based on the information required by the user. I don't want the spreadsheet to be visible to the user. how do i go about doing this and is it even possible? thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a user interface in VBA
Here is an example for a VBA userform that uses two commandbuttons to toggle
it. Private Sub CommandButton1_Click() Application.Visible = False End Sub Private Sub CommandButton2_Click() Application.Visible = True End Sub Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) Application.Visible = True End Sub -- HTH Bob Phillips "bunmi" wrote in message ... hi, i'm trying to create an interface that works with excel in the background. I'm looking to do this in VBA but i'm not exactly sure how to go about doing this. I want to create a form which takes some information from the user and based on this information, it goes back to an excel spreadsheet and a graph or some sort of plot is created based on the information required by the user. I don't want the spreadsheet to be visible to the user. how do i go about doing this and is it even possible? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a user interface form | Excel Discussion (Misc queries) | |||
2007 User Interface | Excel Discussion (Misc queries) | |||
QUI Expert: Excel-based User Interface or OO User Interface? | Excel Programming | |||
GUI Expert: Excel-based User Interface or OO User Interface? | Excel Programming | |||
User Interface | Excel Programming |