View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Clemente Gonzalez Clemente Gonzalez is offline
external usenet poster
 
Posts: 1
Default disabled list box text color

Hi everyone,

I have a series of List Boxes with data that the user select and once all
the selections are made the user pick on a button control to send the data
trough the network to the office administration. When the user pick on that
SEND button the VBA procedure turn the ENABLED property of the List Boxes to
FALSE so their values are protected from been changed by the user. Then
problem is: I need to maintain the text foreground color in black instead of
the gray color assigned by Excel to the disabled control. How can I
accomplish this? Thank You for any suggestions.

Clemente Gonzalez
SCF Architects