ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Revision clouds? (https://www.excelbanter.com/excel-programming/409844-revision-clouds.html)

[email protected]

Revision clouds?
 
Is there anyway to easily make revision clouds around specific cells/
groups of cells in excel?

Thanks,
David

joel

Revision clouds?
 
Is this what you are looking for? The location may need some minor adjustments

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 4/23/2008 by Joel Warburg
'

'
Set Cloud_Loc = Range("B7")
Cloud_Height = 48#
Cloud_Width = 72#
Cloud_Left = Cloud_Loc.Left + Cloud_Width
Cloud_Top = -1 * (Cloud_Loc.Top + Cloud_Height)


ActiveSheet.Shapes.AddShape(msoShapeCloudCallout, _
Cloud_Left, Cloud_Top, Cloud_Width, Cloud_Height).Select

End Sub

" wrote:

Is there anyway to easily make revision clouds around specific cells/
groups of cells in excel?

Thanks,
David



All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com