Mirror Image

[Vijay Anand]

Hi,
I am populating an Excel book as a Database say for each machines.
It contains some conditional formating like, Different colors, Merge cells etc....

I have Front end file with a Display Form.
This Form has a spread sheet.
This Spread sheet depeicts same details as in the database excel sheet.

I am able to show the cell contents, but not the conditional formating like, Different colors, Merge cells etc....

How to make this happen???
Pl help me with a solution.....

I am using EXcel 2003...


Thanks & Regards,
Vijay Anand.R

 

[Andrew Poulsom]

Sorry, but the spreadsheet control doesn't support conditional formatting, merged cells etc.

 

[Vijay Anand]

Thanks Andrew,

Is there any other means to show the exact picture on a Userform.

Ur help would be much appreciated..

Thanks & Regards,
Vijay Anand.R

 

[Andrew Poulsom]

You can use an Image control:

http://www.mrexcel.com/archive2/74600/86520.htm

 

[Vijay Anand]

Thanks again Adrew,
I am almost there..
By the way can we assign a Scroll bar ( Horizontal & Vertical to the Image Control ) for panning across????

Regards,

Vijay Anand.R

 

[Andrew Poulsom]

Sorry, no, the Image control does not have a ScrollBars property. You can set the PictureSizeMode property to fmPictureSizeModeZoom.

 

[Vijay Anand]

Thanks Andrew.
I will try around ur codes...

Cheers!!!

Vijay