Hi James & Mike,
Thanks for your help. Really appreciate it.
Have a good day.
Rgds
Swiftcode
"Mike H" wrote:
> Hi,
>
> add this to James' code:-
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Address = "$A$1" Then 'change to suit
> Application.EnableEvents = False
> If VarType(Target) = vbDouble Then
> Target = Target / 100
> End If
> End If
> Application.EnableEvents = True
> End Sub
>
> Mike
>
> "swiftcode" wrote:
>
> > Hi James,
> >
> > Thanks for your help. Your post solved the inital question, but would it be
> > possible to target only a specific cell.
> >
> > Thanks
> > Swiftcode
> >
> > "Zone" wrote:
> >
> > > Copy this code. Right-click on the sheet tab, select View Code, and paste
> > > the code in there.
> > > James
> > >
> > > Private Sub Worksheet_Change(ByVal Target As Range)
> > > Application.EnableEvents = False
> > > If VarType(Target) = vbDouble Then
> > > Target = Target / 100
> > > End If
> > > Application.EnableEvents = True
> > > End Sub
> > >
> > >
> > > "swiftcode" <(E-Mail Removed)> wrote in message
> > > news:631A1A8B-FB36-42DE-A699-(E-Mail Removed)...
> > > > Hi,
> > > >
> > > > I am wondering if i am able to change the value of an input immendiately
> > > > after pressing enter in a cell. E.g.
> > > >
> > > > If i type "1000" into a cell, after i press enter it will take the
> > > > 1000/100
> > > > and display a value of "10" in the cell.
> > > >
> > > > Thanks
> > > > Swiftcode
> > >
> > >
> > >
|
Similar Threads
