UserForm : Update List is not working : Solved by ( jaslake)

[HaroonSid]

I want to update automatically list but there is error :

Compile error:

Block if without End If

Please Login or Register  to view this content.

[jaslake]

This compiles...

Please Login or Register  to view this content.

[HaroonSid]

an error :

(Run-time error '424'

Object required )

Please Login or Register  to view this content.

[HaroonSid]

the original code is this

in this code i want to add a new name or not and update data

Please Login or Register  to view this content.

[Norie]

You want to add a new name to what?

Where does the new name come from?

[HaroonSid]

Hello Norie FG

First u download the sample file
when u click Show Form
UserForm1 will pop up
in Lable "name" i defined a list ( range "a1:a11" ) in Combobox1
i choose a name from combobox and add some data

if i type a new name which is not in list then
a msgbox appers and ask ("do u want to add this name to list") if
i choose yes then this new name should be add in list (ragne "a1:a11")
and also record should be update

thanx

[jaslake]

Hi haroon2015

I rewrote the Code rather than attemp to modify yours. Your use of Target Cells is inappropriate in this instance. The Code in the attached is a modification of this

'---------------------------------------------------------------------------------------
' Module : Database Form
' DateTime : 31/08/2005 10:55. Updatede 08-02-08
' Author : Roy Cox
' Modified : jaslake 03/21/2014
' Purpose : Data entry form for Excel, with Search facility
'---------------------------------------------------------------------------------------

[HaroonSid]

hello jaslake


Simply Just Awsome


thanx a lot very much for ur hardwork