Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting text is easy... but what about this?!!!
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting text is easy... but what about this?!!!
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting text is easy... but what about this?!!!
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! ------------------------------------------------ ~~ 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting the text without deleting the formula | Excel Worksheet Functions | |||
Easy Question for deleting rows. | New Users to Excel | |||
easy way to delete all rows with no text in them? | New Users to Excel | |||
Make Excel changing text case as easy as in Word!! | Excel Discussion (Misc queries) | |||
Extract Text--Hopefully Easy! | Excel Worksheet Functions |