I'm looking for a way to add something like this in my UserForm.
A long time ago, I used to use an ActiveX component that would let me build a grid. But that stopped working like with Excel 2010. This solution has to run on Windows and Mac (and probably in the browser, too), so no Windows-specific objects. I'm going to need to be able to lock the first two columns. Columns 3 and 4 can be edited. Ideally, column 5 would be a pulldown, And there has to be a way to add new rows (in which case they would have to be able to enter a value in column 1. And there might be more lines than the window displays, so the scrollbars have to work.
Does anyone have any code to share that would work as the foundation for this grid simulator?
I built something like. that when my app that used the grid stopped working, but that app & code have been gone for a long, long time.
Chuck
A long time ago, I used to use an ActiveX component that would let me build a grid. But that stopped working like with Excel 2010. This solution has to run on Windows and Mac (and probably in the browser, too), so no Windows-specific objects. I'm going to need to be able to lock the first two columns. Columns 3 and 4 can be edited. Ideally, column 5 would be a pulldown, And there has to be a way to add new rows (in which case they would have to be able to enter a value in column 1. And there might be more lines than the window displays, so the scrollbars have to work.
Does anyone have any code to share that would work as the foundation for this grid simulator?
I built something like. that when my app that used the grid stopped working, but that app & code have been gone for a long, long time.
Chuck