The One Who Was Posted January 15, 2004 Posted January 15, 2004 Greetings once again: I have a sub that calculates a sum of a column. What I'd like is to have that sub run each time the user makes a change in the datagrid. I've tried using the following events.. TextChanged KeyPress KeyUp Move Navigate Validated None have seemed to fire when I wanted them to. The closest is the Validated event, but it seems rather delayed. If you enter a value into a cell in the datagrid, the compute will not update the text box untill you move to a different cell into the datagrid twice. Rather confusing. Anyone know of a way to resolve this? Or have a suggestion of a different way of completing this task? Quote ~~ The One Who Was ~~
Moderators Robby Posted January 15, 2004 Moderators Posted January 15, 2004 Not sure if this helps.... You can use SelectedCellChange, it is triggered when you first enter a cell. Quote Visit...Bassic Software
The One Who Was Posted January 15, 2004 Author Posted January 15, 2004 (edited) Robby: At first I didn't find the event you mentioned. However, I did run across the CurrentCellChanged event which acts like you mentioned. I thank you very much for the suggestion, it put me in the right track to find the correct event. :eek: I can't believe I didn't find this in the first place. :eek: Edited January 15, 2004 by The One Who Was Quote ~~ The One Who Was ~~
Moderators Robby Posted January 15, 2004 Moderators Posted January 15, 2004 Yeah that's what I ment --- CurrentCellChanged Quote Visit...Bassic Software
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.