My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Adding Pictures to merged cells
|
|
 Mar 18 2008, 11:27 AM
Post
#1
|
|
|
UtterAccess Addict Posts: 107  |
Is there anyway to merge a group of cells together and add a button so that if you click on the button you get the option to add pictures and they fit into the merged cell area only
Thanks for any help |
 |
 
|
|
Mar 18 2008, 01:01 PM
Post
#2
|
|
|
UtterAccess Guru Posts: 722 From: Asia |
Well I am sure It Can't be done with a merged cell. Because the height and the Width of the merged cell is always Assumed as default cell height and width. But you Can make the height and width of your Cell the the desired length of your picture and Try with some code like this:
CODE Sub PictureLength() ' ' Macro1 Macro ' Macro recorded 18-03-2008 by Ali ' ActiveSheet.Shapes("Picture 2").Select With Selection .ShapeRange.LockAspectRatio = msoTrue .ShapeRange.height = ActiveSheet.Range("B4").height .ShapeRange.Width = ActiveSheet.Range("B4").Width End With Sheet1.Shapes("Picture 2").Left = Range("B4").Left Sheet1.Shapes("Picture 2").Top = Range("B4").Top End Sub Let me know if you need more assistance ? |
|
|
|
|
Mar 18 2008, 01:03 PM
Post
#3
|
|
|
UtterAccess Guru Posts: 722 From: Asia |
Post deleted by aali_dad
|
|
|
|
|
Mar 18 2008, 01:05 PM
Post
#4
|
|
|
UtterAccess Guru Posts: 722 From: Asia |
TAke a look at the Attachement .
May be it helps you to get there. Edited by: aali_dad on Tue Mar 18 14:09:52 EDT 2008.
Attached File(s)
|
|
|
|
|
Mar 18 2008, 03:19 PM
Post
#5
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
QUOTE Is there anyway to merge a group of cells together Although what you ask is possible, and Ali may have helped you out already, I strongly recommend not to use merged cells particularly if you want to handle them via VBA... merged cells are a nightmare, believe me, and it's not just my opinion (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif) Why can't you a) resize the rows and columns or b) place the picture on top of multiple cells? Martin |
|
|
|
|
Mar 19 2008, 12:06 AM
Post
#6
|
|
|
UtterAccess Guru Posts: 722 From: Asia |
Yes Martin
QUOTE merged cells are a nightmare I have the same opinion with Merge Cells. You know I was trying to get the height and width of a merged cell though the height was some where between 80 to 90 but in vba It was showing me 15.75. Uh How could it be possible. Not only this I had lots of problem working with merged cells and now I quit using merged cells. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 04:23 AM |