Turn spreadsheet calculation into User form or App

[gazmoz17]

Hi,

I have no experience of userfroms. Is it possible to make columns A:E a user form or look more formal and app like?

Ideally so users could drag it around on desktop as its own little popup window?

Am I able to post the actual file as an attachement?

Its basically an input calculation looking up postcodes and index/match to 2 lookup tables.



Many Thanks
Gareth

 

[gazmoz17]

Been using it today mate, works really really well Don't want to be lazy and ask for a few tiny revisions….Want to do a bit of research on how userforms work and if I can have a go myself. But no doubt I’ll be back to ask you how to add to it

Thanks again

 

[sxhall]

Been using it today mate, works really really well Don't want to be lazy and ask for a few tiny revisions….Want to do a bit of research on how userforms work and if I can have a go myself. But no doubt I’ll be back to ask you how to add to it

Thanks again

Glad to have helped.

I must admit I do like a Userform in Excel, have written complete applications that solely uses Userforms!