Pop Up Menu Scroll Bar & Formatting Text With Colours

[Excel-Access]

Dear Excel Community

Can someone kindly assist.

I have attached the following macro file with a pop up and would be grateful if someone could advise or modify the coding to show

If you click the Final Check Button

1. The pop up box extends my whole laptop page and if possible I would like a vertical scroll bar if possible

2. Is it possible to make Severance in Red & Bold?

3. Is it possible to make non Severance in Dark Blue & Bold?

4. Whereit says Please ensure that in Column E .......... is it possible to make this flash - if not can I have it in Black and Bold

Any help will be appreciated

[humdingaling]

your Q1:

Please Login or Register  to view this content.

Re:2,3,4
do you mean in your text box?

[humdingaling]

i assume you want to scale to text box as well
also i assume you wanted the scroll bar on the text box rather than the form itself

Please Login or Register  to view this content.

if so add more code

[humdingaling]

Re: different font colour/formats in one text box....have not come across a way of doing it

MS have some custom control called inkedit that can do it but i have zero experience with it
here's what i could find about it
http://stackoverflow.com/questions/2...r-in-vba-excel

alternatively you can split your text boxes and adjust the height to be dependent of the number of lines and adjust subsequent start (TOP,LEFT) of text boxes

Re:Flashing
you could possibly do it with timer...its pretty fiddly
using the same principle as these but in form
http://www.cpearson.com/excel/BlinkingText.aspx
http://excel.tips.net/T002134_Flashing_Cells.html