How to move the controls from sheet to userform

[Nader]

I created many controls ( commands, textbox, listbox...) with their code on the sheet. I want to move them with their code to the userform. Is there any way. It's need a big job to creat them again with their code.

[lynnnow]

can u show how big your sheet project looks like?

[Bob Phillips]

I think you are stuck with doing it manually, I know of no way to automatically do it.

Shows the value of proper design.

[lynnnow]

xld: Can a sheet with controls be converted to an html (with the SaveAs option) and still work as intended as an Excel spreadsheet?

[lynnnow]

ok, tried it out myself, but it doesn't work out the way it should.