Tags: create, creating, excel, interface, microsoft, msdn, software, thebackground, user, vba
Creating a user interface in VBA
On Microsoft » Microsoft Excel
1,856 words with 1 Comments; publish: Fri, 06 Jun 2008 08:50:00 GMT; (30646.88, « »)
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!
http://excel.itags.org/q_microsoft-excel_105569.html
All Comments
Leave a comment...
- 1 Comments
- 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" <bunmi.excel.itags.org.discussions.microsoft.com> wrote in message
news:41D13513-F489-4E68-81E1-FB2046462DB6.excel.itags.org.microsoft.com...
> 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!
#1; Fri, 06 Jun 2008 08:51:00 GMT