FLoating Shape in excel

Question

Hi guys, i want to create a floating rectangular shape for my project in excel....please help to create VBA code..thnks

Answer 1

Still not enough information. What is this shape? Is it a picture or what is it? What is the purpose of "floating" it?

The only way I know of positioning something on the screen so it stays in position when the screen scrolls is to have a Userform and position a shape on it but it depends on what the shape is as to whether this can be achieved.

Like I indicated previously you need to totally specify what you are trying to achieve otherwise I can't even guess at what you want. If it will help to explain then upload a copy of your workbook to OneDrive.

Guidelines to upload a workbook on OneDrive. (If you already use OneDrive and your process for saving to it is different then you can probably start at step 8 to get the link but please zip the file before uploading.)

1. Zip your workbooks. Do not just save an unzipped workbook to OneDrive because the workbooks open with On-Line Excel and the limited functionality with the On-Line version causes problems.
2. To Zip a file: In Windows Explorer Right click on the selected file and select Send to -> Compressed (zipped) folder.)
3. Do not use 3rd party compression applications because I cannot unzip them. I do not clog up my computer with 3rd party apps when there are perfectly good apps supplied with windows.
4. Go to this link.  https://onedrive.live.com
5. Use the same login Id and Password that you use for this forum.
6. Select Upload in the blue bar across the top and browse to the zipped folder to be uploaded.
7. Select Open (or just double click). (Be patient and give it time to display the file after initially seeing the popup indicating it is done.)
8. Right click the file on OneDrive and select Share.
9. Select "Get a Link" from the popup menu.
10. Click Copy the link and Paste into your reply on this forum.

Answer 2

I want to create the code manually to position my designed shape..i got multiple of sheets and i want the  objects to float  in every sheets even in scrolling....freez pane is limited...u can only freez once..please help..

Answer 3

Need more information.

Do you want code to create the floating shape or do you want to create the shape manually and need code to position the shape when and where required.

What type of shape do you required?

Will there be only one shape or multiple shapes?

What are the conditions that set where the shape is to be positioned? Do you want to select a cell and the shape is positioned alongside of the selection or what?

Do you want the shape to be visible all of the time or only under specific conditions? If under specific conditions, then what are these conditions.

Just a note for information. Most of the work in creating programs is determining what is required (called Systems Design) and when that is done (and if done properly), then the coding is the easy part.