View Single Post
  #25  
Old April 27th, 2009, 02:22 PM posted to microsoft.public.excel.worksheet.functions
Luciano Paulino da Silva
external usenet poster
 
Posts: 52
Default Macro to apply parsing rules for strings and list the substrings(0/1)

On 24 abr, 08:29, Ron Rosenfeld wrote:
On Sun, 19 Apr 2009 08:02:47 -0700 (PDT), Luciano Paulino da Silva

wrote:
Dear Ron,
You are correct that it would be better to input the parameters (rule
(s) and number of
skips) via a user form, instead of multiple Box. It would be great to
select the rules and eventually skips. Could you help me with this?
Thanks in advance,
Luciano


When you open the VB Editor, you can select Insert/User Form and develop one
from there.

I changed the code a bit to make it more compatible with the user form, and
also added code to the userform to handle the inputs, but I don't know how to
transmit the information on the user form layout itself in text form as is
required by this NG.

I will try to attach the workbook to this message. *If that does not work,
you'll have to give me a place to send it.

The code does need some work, in addition to needing to have more of the rules
codified.
--ron


Dear Ron,
If it is possible you could send me the workbook by e-mail at

Thanks in advance,
Luciano