Hi,
I am creating a simple utility in Excel which will compare two data extracts and report the differences. I have created two listboxes and buttons which allow users to map the field names from one extract to the field names of the other extract.
I created these listboxes in a userform first, but I wanted to dress it up a little bit and make it look more professional. I find it easier to add shapes, pictures, and move controls around in worksheets so I have the controls embedded in a worksheet now, but I notice there is a slight lag and it seems to run a bit slower.
Are there pros and cons to having controls in a worksheet or any best practices? I want the utility to feel more like a polished application and I find I can do this easier in the worksheet.
Any suggestions would be helpful.
I am creating a simple utility in Excel which will compare two data extracts and report the differences. I have created two listboxes and buttons which allow users to map the field names from one extract to the field names of the other extract.
I created these listboxes in a userform first, but I wanted to dress it up a little bit and make it look more professional. I find it easier to add shapes, pictures, and move controls around in worksheets so I have the controls embedded in a worksheet now, but I notice there is a slight lag and it seems to run a bit slower.
Are there pros and cons to having controls in a worksheet or any best practices? I want the utility to feel more like a polished application and I find I can do this easier in the worksheet.
Any suggestions would be helpful.
