Are you familiar with userforms. You can create a userform that can
solicit, interpret and act on the data in one step.
If you are, then what do you need help with.
If not, you might look at these:
http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"
Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97
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
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
John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips
Peter Aiken Articles:
watch word wrap. the URL should all be one line.
Part I
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartII.asp
--
Regards,
Tom Ogilvy
ian123 wrote in message
...
I am trying to create a macro that will do the following...
On running a box pops up on screen asking if you would like to:
a. Delete no. of leading characters
b. Delete no. of ending characters
c. Delete all charaters after nth character
On clicking the repective action a second box will appear allowing the
user to enter the relevant number and on clicking ok the requested
action will be performed.
Unfortunately i am nowhere near clever enough to do this and turn to
your collective genius for help..!!!
Many thanks
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements