View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SailFL SailFL is offline
external usenet poster
 
Posts: 6
Default Two UserForm Questions

Norman,

Thanks for both of the suggestions. They are working and I appreciate your
help.

I changed my user name on the site.
--
SailFL


"Norman Jones" wrote:

Hi FL Consultant,

1) I am using a MultiPage in a UserForm. I want to change the color of
the
pages in the Multipage. You can not do it through the properties. Can
you
do it in code?



See the followimg thread:

http://tinyurl.com/8zmxq


2) I want one of the pages in the MultiPage to be a place where the user
can
add notes. I tried making a textbox large but it does not accept carriage
returns. Once again is this a property change or do I have to create a
small
word process function to be able to have the user add notes.


If I set the multipage tab's text box's multiline value to true, I was able
to insert carriage returns without problem.



---
Regards,
Norman



"FL Consultant" wrote in message
...
1) I am using a MultiPage in a UserForm. I want to change the color of
the
pages in the Multipage. You can not do it through the properties. Can
you
do it in code?

2) I want one of the pages in the MultiPage to be a place where the user
can
add notes. I tried making a textbox large but it does not accept carriage
returns. Once again is this a property change or do I have to create a
small
word process function to be able to have the user add notes.

Thanks you for your help.
--
FL Consultant