simple vba queries.. please help..

[gauravgrover]

Ques 1: I want that when i send the excel file to somebody then he
should see only vb screen not my excel data sheet.. so it should open
with vb page as its front page. How can it be done?

Ques2: When we are accessing data from an excel file to vb's textbox
can we use data from different sheets like (normally it is
Range("A1").value=36) now if i want to have 3 statements like
sheet1.range("A1").value =36, sheet2.range("A1").value
=34,sheet3("A1").range.value =78. Can u give me a solution of this
situation?

 

[Tom Ogilvy]

Possibly use the worbook_open event to hide the application and display your
userform.

See Chip Pearson's page on events for an overview:
http://www.cpearson.com/excel/events.htm

you can use code to assign values from any sheet to the textbox or as an
alternative you can link you textboxes to any sheet by using an argument like

sheet1!A1
sheet2!A1
sheet3!A1

 

[Ivan Raiminius]

Hi,

to ques 1:
in workbook_open event procedure you can use statement like this:

Application.VBE.Windows.Item(1).SetFocus

to ques 2:
I am afraid I don't understand your question. Could you re-phrase it?

Regards,
Ivan