View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default No clue whatsoever, so thought I'd ask the experts Pt II

Thanks for your help Guys n Dolls...

Next...

If I created my own UserForm to make it look like I wanted, would I still be
able to use this VB Code? How would I then enter Open and Close boxes?

Secondly on the VB below, how would you write it so that only a certain
amount of characters can be typed in the answer e.g I want a 32 character
length cell size

Thx

Paul

"Gary''s Student" wrote:

Good catch!

The universe keeps telling me to use Option Explicit; some day I will learn
to listen.
--
Gary''s Student - gsnu200829


"Susan" wrote:

TYPO ALERT

For i = 0 To 2

that's a zero, not a letter o.

:)
susan


On Jan 27, 10:15 am, Gary''s Student
wrote:
How about:

Sub AskMeNoQuestions()
Dim s(3)
s(0) = "What is the meaning of life?"
s(1) = "How many neutrinos are there in the universe?"
s(2) = "Why are the key pads on phones and computer keyboards different?"
For i = o To 2
x = Application.InputBox(prompt:=s(i), Type:=2)
j = i + 1
Cells(j, 1).Value = s(i)
Cells(j, 2).Value = x
Next
End Sub