Excel Button Help??

[greygrendon]

Morning All

I want to create a button so when I press it, it creates a pop-up window. In this pop-up, you can type a value, which will then transfer to a specific cell. In my spreadsheet, I want to change a UK Postcode, but as others will be using the spreadsheet, I need the cell to be protected. So if i create a macro so to change the postcode, you press the button and enter the new postcode in a popup window so the cell is still protected.

Any help is greatly appreciated.

Matt

 

[RedBeard]

You'll need an inputbox: https://msdn.microsoft.com/en-us/library/office/ff839468.aspx

You'll want to work with this to protect your cell: https://msdn.microsoft.com/en-us/library/office/ff836172.aspx

Rock on!