var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I want to go back to my previous selected cell, in wich I had just entered a new value. After that I want to do a control in on this entry. How do I have to take that in my VBA code (so to select that cell again)?
You can use SheetChange method. This mothod will fire everytime you make some change.....
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox "Row:" & Target.Row & " Column:" & Target.Column
if you need it just for checking entered value, maybe VALIDATION would do your job.... go to TOOLS-VALIDATION or use VBA Validation Object - it's the same.
Last edited by playernovis; 04-12-03 at 00:40.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors