User forms

P

pobuckley

Rather than linking excel to a VB front end, how powerful are the VB
userforms? If I want to create a front end of my excel workbook with
sheets which will just display information that the cells calculate th
how hard would this be?

I also want to try and hide the fact that it is an excel spreadsheet?

Thanks in advance

Padrai
 
D

DNF Karran

Shouldn't be too hard, especially if you know VB!

To hide the fact the file is in excel you can do things such as hidin
worksheets and also hiding toolbars when the worbook_open event i
triggered. This can also be used to trigger the userform load.

At the end of the day though, an excel "splash" screen shows whil
excel loads so while you can make the file look like an independan
application, the users will be able to see the fact it is excel based.

You may also encounter problems if the user disables macros on open.

Dunca
 
P

pobuckley

Thanks

I have not created a form but how do I display the cells I want t
show?

I know in VB that I would use a data grid or some other sort of add i
but I though that by using VBA I could simply show the excel cells a
part of my user form?

Am I missing something?

Thank
 
D

DNF Karran

As far as I know there is no capability in xl to show cells directly o
a userform. You can only use the cell values to populate items on you
form (combo boxes, list boxes ets).

Something like this will do that for you

Private Sub UserForm_Initialize()
With Me.TextBox1
.Value = ThisWorkbook.Sheets(1).Range("a1")
End With
End Sub

Dunca
 
Top