LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default InputBoxes

Hi,

I've created a button to allow a user to add comments to a protected
sheet. I have this code below:

Sub Add_comment()
Dim comment As Variant
ActiveSheet.Unprotect Password:="55555"
comment = InputBox("Enter Date Here")
If comment = False Then Exit Sub
ActiveCell.NoteText comment
ActiveSheet.Protect Password:="55555"
End Sub

I would like to have two input boxes that populate one comment. I want
the user to be prompted to insert the date (or have the date
automatically pulled in) and have a second prompt that asks the user to
input the comment, so that there comment shows up with the date and
what they are saying.

Thank you,

Sean

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Positioning Userforms, InputBoxes Pflugs Excel Discussion (Misc queries) 1 July 10th 07 06:12 PM
InputBoxes Exceptions ianripping[_42_] Excel Programming 3 April 8th 04 09:34 PM


All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"