Thread: Macro to apply parsing rules for strings and list the substrings
View Single Post
  #23  
Old April 24th, 2009, 12:34 PM posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
external usenet poster
  
Posts: 3,719
Default Macro to apply parsing rules for strings and list the substrings - ParseLongStrings2.xlsm (0/1)
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

On the VBA menu, you start with Insert/UserForm.

I modified the code of the macro to work better with the user form, and also
produced code for the user form itself. But I don't know how to transmit the
userform layout in text fashion.

Let's see if I can attach a file to this message.
--ron