×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

pop-up window in a spreadsheet????
3

pop-up window in a spreadsheet????

pop-up window in a spreadsheet????

(OP)
HI all....
The forum is so active with muti disciplinary ppl....Gud stuff.
Here i need a favour...

I made a excel spreadsheet.I want, once the  spreadsheet opens,a pop-up window should come which will be showing "NOTE......These are the following assumptions 1.......2......so on." The user must read this before he gets onto work with the spreadsheet. looks litbit dynamic activity,but.....

Do someone suggests me ,how can i succeed in this activity

RE: pop-up window in a spreadsheet????

VBA, AutoOpen event.

RE: pop-up window in a spreadsheet????

Paste the following sample into the workbook code pane

CODE

Private Sub Workbook_Open()
Const MSG As String = "NOTE......These are the following assumptions" _
                      & vbCrLf & "1......." _
                      & vbCrLf & "2......." _
                      & vbCrLf & "so on."
MsgBox MSG, vbInformation, "Assumptions"
End Sub

RE: pop-up window in a spreadsheet????

Tht above may be self-explanatory, but just to make sure you paste it in the right place:

Tools / Macr / VBA editor

Double Click on "this workbook" in project explorer upper left to open the workbook code window.

On the code window top toward left, change "general" to "workbook"

On the code window toward the right, select open.

It will autogenerate
Private Sub Workbook_Open()
End Sub

Paste the above code in there (deleting redundant parts).

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: pop-up window in a spreadsheet????

Sorry, I guess I made that more complicated than need be. Should be able to paste into the general code window for the workbook and the subroutine heading takes care of the rest.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: pop-up window in a spreadsheet????

(OP)
Fantastic .............awsum.
g8 job.....Thanks buddy...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources