Open user form upon enter key press

[ipbr21054]

Hi,
On my worksheet i have in column A customers names & in column P of that row is the receipt number for that customer.
What i would like to happen is when a certain customers name in cell A is selected when i press the enter key have it open my userform called Database & if possible to then take it one step further upon opening the userform have that customers records loaded.

I can assist further with info etc should you need any other input.

Thanks

 

[Domenic]

x = .Cells(.Rows.Count, 1).End(xlUp).Row

That's because the variable x has not been declared. With Option Explicit at the top of your module, all variables must be declared. Since it looks like it's a local variable, you should declare it within UpdateRecord_Click.

 

[ipbr21054]

Well im not sure how to do that & are you saying this could also happen with other buttons etc on the userform ?

 

[ipbr21054]

Dont take this as being rude but it was working fine before i used this new code so the variable was working fine then.
Dont see how it has now stopped or how to fix it

Thanks

 

[Domenic]

With Option Explicit, all variables must be declared. So you'll need to declare x like this...

[COLOR=#333333]Private Sub UpdateRecord_Click()[/COLOR]
Dim C As Range
Dim i As Integer
Dim msg As String
[COLOR=#ff0000]Dim x as Long[/COLOR]
[COLOR=#333333]If Not IsComplete(Form:=Me) Then Exit Sub
[/COLOR]'etc
'
'
End Sub

I haven't looked through the rest of your code, but if you have other variables that are not declared, you'll get the same error.

 

[ipbr21054]

Many thanks youve been a great help to make this happen.

Now sorted so have a nice day.

 

[ipbr21054]

Hi,

Would you be so kind to take a look at this and advise why the code doesnt update.

https://www.mrexcel.com/forum/excel...-first-entry-drop-down-list-not-last-1-a.html