Check your email.

The workbook has code in it...

--
steveB

Remove "AYN" from email to respond
"Larry Sartoris" wrote in message
...


"STEVE BELL" wrote:

Send me your email and I'll send you an example workbook

--
steveB

Remove "AYN" from email to respond
"Larry Sartoris" wrote in
message
...
Could you give me an example please?
inside of an inputbox
Select a fruit:
Apple, peach, pear

"STEVE BELL" wrote:

You can creat "forms" in code and than include
"Listboxes" or "ComboBoxes"

Each of these contain a list of items to choose from.

--
steveB

Remove "AYN" from email to respond
"Larry Sartoris" wrote in
message
...
Ok I got another good question. Is there a way to make a pop box
with
a
drop
down menu?

"Larry Sartoris" wrote:

Thanks so much you've been a great help in short amount of time.

That would have taken me forever to figure out. Again thank you
both...

Larry

"Chip Pearson" wrote:

If you name a macro Auto_Open, it will automatically execute when
the sheet is opened. E.g.,

Sub Auto_Open()
Dim S As String
S = InputBox("Enter Something")
If StrPtr(S) < 0 Then
Range("A1").Value = S
Else
' user clicked cancel
End If
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Larry Sartoris" <Larry wrote
in message
...
Ok I'll try to use an inputbox. I work better with examples do
you think you
could give me a small example of using an input box when an
excel sheet is
opened? Thanks

"Chip Pearson" wrote:

The easiest way is to use an InputBox.

Dim S As String
S = InputBox("Enter Something")
Range("A1").Value = S


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Larry Sartoris" <Larry
wrote
in message
...
I'm trying to make a pop up and then have the user enter
data
into the pop
up. Then use that data to make calculations in the excel
sheet. Too
complicated for excel?

Let me know if I confused you at all

Thanks for any help.