ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Two UserForm Questions (https://www.excelbanter.com/excel-programming/337595-two-userform-questions.html)

FL Consultant

Two UserForm Questions
 
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

Norman Jones

Two UserForm Questions
 
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




SailFL

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






All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com