Hi all,
I'm working for a small company and I have an Excel dataform with more than 32 columns (therefore the add-in is not possible).
I would like to have a clearer overview. Therefore I want to display the data as a dataform.
The enhanced dataform of John Walkenbach is not what I want.
- I don't need the buttons to change rows
- I prefer a small button at the beginning of the row with 'oper or display this row as a dataform'
- It is really important that the changes save if I press Enter
- Change the cells -> also the cells that contain formulas (I want to change the formula)
- I prefer not to scroll, thus (like in the attachement) I prefer to display the data in two columns
Does anyone know (all of this, what a demands haha) if this is possible or is there a vba code available for this?
I have some experience with programming, maybe it is possible to change the John Walkenbach code for this?
Thanks.
Jette
Bookmarks