Greetings !

I have this code -

Ans = InputBox("Enter 1 for " & Text1 & vbCrLf & _
" 2 for " & Text2 & vbCrLf & _
" or 3 for " & Text3," Select choice" )

What I would prefer is to have displayed in the box three
labelled buttons, such that the user can more easily
select a choice.

Suggestions as to the easiest way to achieve this would be
welcome.

I have NEVER yet used a "form",
so that would be "a whole new ball-game" ("can o' worms" ?)
that I would prefer to avoid !

RClayAThaswellDOTcom

I don't think this is possible without using your own
userform

Rog


-----Original Message-----
Greetings !

I have this code -

Ans = InputBox("Enter 1 for " & Text1 & vbCrLf & _
" 2 for " & Text2 & vbCrLf & _
" or 3 for " & Text3," Select choice" )

What I would prefer is to have displayed in the box three
labelled buttons, such that the user can more easily
select a choice.

Suggestions as to the easiest way to achieve this would
be
welcome.

I have NEVER yet used a "form",
so that would be "a whole new ball-game" ("can o'
worms" ?)
that I would prefer to avoid !

RClayAThaswellDOTcom
.

As Rog said, you really need a userform for this and it isn't that hard:
Here are some sources of information.

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://support.microsoft.com/default...;EN-US;Q168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

--
Regards,
Tom Ogilvy



"Robin Clay" wrote in message
...
Greetings !

I have this code -

Ans = InputBox("Enter 1 for " & Text1 & vbCrLf & _
" 2 for " & Text2 & vbCrLf & _
" or 3 for " & Text3," Select choice" )

What I would prefer is to have displayed in the box three
labelled buttons, such that the user can more easily
select a choice.

Suggestions as to the easiest way to achieve this would be
welcome.

I have NEVER yet used a "form",
so that would be "a whole new ball-game" ("can o' worms" ?)
that I would prefer to avoid !

RClayAThaswellDOTcom

Thank you, Tom and Rog, for your help.

I guess I had better start to learn about
UserForms....<Sigh

And Thank you, Tom, for your help yesterday - I sent a
thank you to your msn address, but it bounced....


-----Original Message-----
As Rog said, you really need a userform for this and it
isn't that hard:
Here are some sources of information.

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by
Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?scid=KB;EN-
US;Q168067
File Title: Microsoft(R) Visual Basic(R) for Applications
Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to
manipulating
UserForms in Microsoft Excel 97. It includes examples and
Microsoft Visual
Basic for Applications macros that show you how to take
advantage of the
capabilities of UserForms and use each of the ActiveX
controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-
us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-
us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

--
Regards,
Tom Ogilvy



"Robin Clay" wrote
in message
...
Greetings !

I have this code -

Ans = InputBox("Enter 1 for " & Text1 & vbCrLf & _
" 2 for " & Text2 & vbCrLf & _
" or 3 for " & Text3," Select
choice" )

What I would prefer is to have displayed in the box
three
labelled buttons, such that the user can more easily
select a choice.

Suggestions as to the easiest way to achieve this would
be
welcome.

I have NEVER yet used a "form",
so that would be "a whole new ball-game" ("can o'
worms" ?)
that I would prefer to avoid !

RClayAThaswellDOTcom


.