Lock a form to a spreadsheet

[ndjustin20]

Is there a way for me to place a form on a spreadsheet so it doesn't move when cells are moved and I don't have to click a button or change something to make the form appear and stay in place? I'm trying to create a dash board using information entered into a spreadsheet so the form functions will evaluate everything then display the answers though I'm having trouble figuring out how to make a form appear after I've created it in a certain location then making it stay in that location.

Thank you for you help it's much appreciated

Justin

 

[ndjustin20]

I was able to get the form to open when the work book opened though is there a way to lock it to a specific place on the workbook and also make it so you can make changes to the worksheet without having to close the form?

 

[Sahak]

Hi Justin,

1. I’m not sure if it possible to “Lock” form to worksheet .
2. If you change form’s “ShowModal” property to “False”, then you can make changes to the worksheet without having to close the form.

 

[ndjustin20]

I'm pretty certain you are correct as I've looked everywhere and can't find anything that says you can drag a form to a specific spot and it'll stay there I didn't know about the showmodal property though and really appreciate the information as that is something I will use in the future Thank you very much for your response today!!!


Justin

 

[Sahak]

You're welcome.