How to draw lines to seperate data
 

This works great for what I need it to do. How do I put it a user form
so I can select which columns to apply the lines to if they are not in
column A or B.

Thanks for your assistance!

Garry


--
garrylwhiting
------------------------------------------------------------------------
garrylwhiting's Profile: http://www.excelforum.com/member.php...o&userid=16214
View this thread: http://www.excelforum.com/showthread...hreadid=276298

How to draw lines to seperate data
 

Garry

What are we starting with? A userform with two (or more?) comboboxes that
are filled with column headings (or column letter?) and a commandbutton to
do the formatting? Do you need help setting up the userform, changing the
macro that does the formatting, or both?

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"garrylwhiting" wrote in
message ...

This works great for what I need it to do. How do I put it a user form
so I can select which columns to apply the lines to if they are not in
column A or B.

Thanks for your assistance!

Garry


--
garrylwhiting
------------------------------------------------------------------------
garrylwhiting's Profile:
http://www.excelforum.com/member.php...o&userid=16214
View this thread: http://www.excelforum.com/showthread...hreadid=276298

How to draw lines to seperate data
 

Garry

P.S. If you like using excelforum to access these NNTP groups, you should
complain to the webmaster that replies to messages don't show up correctly
in NNTP readers (like Outlook Express). I found that you replied to me by
accident because your message doesn't show as a reply to my message and
therefore isn't highlighted. In the meantime, if I don't get back to you in
a day, or so, send me an email that you replied. I won't ignore you on
purpose, but there's a lot of messages in this group and those that aren't
replies to mine are easily missed.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"garrylwhiting" wrote in
message ...

This works great for what I need it to do. How do I put it a user form
so I can select which columns to apply the lines to if they are not in
column A or B.

Thanks for your assistance!

Garry


--
garrylwhiting
------------------------------------------------------------------------
garrylwhiting's Profile:
http://www.excelforum.com/member.php...o&userid=16214
View this thread: http://www.excelforum.com/showthread...hreadid=276298