deleting text is easy... but what about this?!!!

I

ian123

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
 
T

Tom Ogilvy

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-us/dnoffpro01/html/IntroductiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFo
rmsPartII.asp

--
Regards,
Tom Ogilvy


ian123 said:
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
Click to expand...
creating financial statements
 
I

ian123

Thanks for your help, i have mimimal knowledge of vba (learning by
experimentation and examples!!!). I'll have a look at the sites you
recommend and give it a go.

In the meantime if anyone else has done anything like this i'd
appreciate any pointers!
 
Top