Posts by saeedabs

Re: Searchable / Auto Complete Data Validation List

Use this Add-in

in the new tab ( that will be added when you add the add ins) you can run a new feature , make it default for every data validation list , it will help

Re: Searchable / Auto Complete Data Validation List

seems very interesting

Re: Macro to copy data ny if not duplicated

WoWWWWWWWWWWWWWW

thanks a millions :oz:

works like a charm

Re: Macro to copy data ny if not duplicated

i find this code

is it good?

Sub unique_column()


Dim data() As Variant 'array that will store all of the unique letters


c = 1


Range("A1").Select




Do While ActiveCell.Value <> ""


    ReDim Preserve data(1 To c) As Variant


    If IsInArray(ActiveCell.Value, data()) = False Then 'we are on a new unique letter and will add it to the array
        data(c) = ActiveCell.Value
        c = c + 1
    End If


    ActiveCell.Offset(1, 0).Select


Loop


'now we can spit out the letters in the array into a new column


Range("B1").Value = "Unique letters:"


Dim x As Variant


Range("B2").Select


For Each x In data()


    ActiveCell.Value = x


    ActiveCell.Offset(1, 0).Select


Next x


Range("A1").Select


c = c - 1


killer = MsgBox("Processing complete!" & vbNewLine & c & "unique letters applied.", vbOKOnly)




End Sub


Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean


    IsInArray = (UBound(Filter(arr, stringToBeFound)) > -1)


End Function

Re: Macro to copy data ny if not duplicated

yes, but this data will be replace every time, but i want to databank sheet keep previous data constantly

Re: Macro to copy data ny if not duplicated

i want that when enter data only in range a2 :d2 (sheet 1) , then push a button , this button do this functions:

if ID is exist in "databank" sheet ( column a ) , Prompt me that it s duplicated , so do nothing in "databank" sheet

but if the id is not existed in "databank" sheet

then add new row to existing datas

and so on ...

Re: Macro to copy data ny if not duplicated

yes

Re: Macro to copy data ny if not duplicated

thanks bro , but now copy isnt working

Re: Macro to copy data ny if not duplicated

thanks a million master KJBOX

there is only one thing : i want it to let me enter datas if it not exist in "databank" sheet,only duplications are forbidden

Re: Macro to copy data ny if not duplicated

any idea?

hi dears

i have this file

i want to enter data in sheet 1 and if not existed in "databank" sheet , then copy in data bank sheet and if exist do nothing .

how can i do these?

Re: Update worksheet from user form based on a text box entry

Any new way?

Re: Update worksheet from user form based on a text box entry

Thanks so much for your help thus far8-)

Re: Update worksheet from user form based on a text box entry

thank youuuuuuuuu

Re: Update worksheet from user form based on a text box entry

Quote from KjBox;792236

I have added the new code to the file you attached in your last post. It works now.

When you use the double click method to edit a data row then the Part Number text box will have red text because when the user form loads that text box changes from empty to the seleted part number, that will trigger the code you have that checks if that part number already exists (which, of course, it does) and makes the text red for an existing part number.

Personally, I would not use 2 methods of editing data, that can confuse users. Nor would I use either of the methods you now have. If I get a chance later today I will create a user form with an alternative method.

i want something that when you enter a number in "shsanad" text box it searchin column A in "forms sheet" and retrieve related data, and if you want editthem and if it not exist then insert that data in "formssheet" .

and thanks again for your patience :flower::flower:

Re: Update worksheet from user form based on a text box entry

yes , because i was waiting, and i was very shamed to bother you , so i asked this way :grin:

Re: Update worksheet from user form based on a text box entry

Any Idea ?

Re: Update worksheet from user form based on a text box entry

thank you

Re: Update worksheet from user form based on a text box entry

Sorry dear jkbox

i made some changes in userform

i add some lables shows that textbox entry is number or text

Re: Update worksheet from user form based on a text box entry

there is two issue

1- userform shows error alarm even if the data exist, for example number 25

( textbox number also changes to red color if it exist in data sheet)

2- former i can edit in datasheet by clicking on cells ( it showed userform) but now it refers this code as an error :

ctl = Cells(lRow, CInt(ctl.Tag))