Mirror Image

Vijay Anand

Board Regular
Joined
Jan 21, 2008
Messages
69
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,
Vi:)jay Anand.R
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Sorry, but the spreadsheet control doesn't support conditional formatting, merged cells etc.
 

Vijay Anand

Board Regular
Joined
Jan 21, 2008
Messages
69
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:)
 

Vijay Anand

Board Regular
Joined
Jan 21, 2008
Messages
69

ADVERTISEMENT

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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Sorry, no, the Image control does not have a ScrollBars property. You can set the PictureSizeMode property to fmPictureSizeModeZoom.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,694
Messages
5,597,571
Members
414,156
Latest member
WDMix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top