inputbox not showing value of cel to adjust and does show when in next cel and going back

[littlepete]

hello

i am currently working on an inputbox to fill in new data in a new last row, and that's working perfectly !

now i'm trying to adjust the macro to go through all data of an existing row.
when going from K to Z it does not show the data of the column in the active row.
but when i type 99 (case go back to column -1) it does show the data ...

what do i need to adjust ?

keuze = InputBox(Chr(10) & _ 
    "Deze lijst bevat " & aantalcontacten & " contacten." & Chr(10) & Chr(10) & _ // [I]list containing x contacts[/I]
    "tik 0 om dit scherm te verlaten." & Chr(10) & _
    "druk 99 om naar het vorige gegeven terug te gaan." & Chr(10) & _ // [I]type 99 to select column -2 from D to C (for.ex.)[/I]
    " druk 55 om bestaande gegevens te wijzigen." & Chr(10) & _
    "druk ENTER voor volgende gegeven." & Chr(10) & _ // [I]press enter to continue without changes[/I]
    "______________________________________________________" & Chr(10) & Chr(10) & _
    Cells(titelrij, dezekolom).Value & " invullen: ..." & Chr(10) & _
    "nu: [ " & Cells(nieuwerij, dezekolom).Value & " ]" & Chr(10), _
    UCase(Cells(nieuwerij, dezekolom).Value & " INVULLEN [ " & dezekolom & " van 96 ]"), antwoord, 11000, 10000)

thank you for your point of view !!!

 

[littlepete]

fixed it.

 

[Fluff]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.