Posts by alhagag

Mumps you did a great work may you mod the code if I have all the row is filling before the total and no empty row I would when I fill data on userform then copy the data before row total without insert empty row after it as in the current code do it

hello

I have this simple file if any body idea about how I can fill the empty row based on column from multiple textbox to sheet based on selected item from combobox please provide me

well done ! thanks so much for your assistance

great work ! just I would some updating please if b1 ="" or the value nothing is existed , then the range b2: b7 should be empty , currently show error #N/H , could you fix it?

hello

I have this file and put the result in sheet "result" the search is based on column a across multiple sheets if is possible do that without button when run the macro like worksheet change event

thanks in advance

ok , I fill more data and attach a new file

did you test it?

your file in post#11

yes this is way to filter data what I want but I no know what I say you the file contain problem sometimes filter data right and often wrong when I filter item "dell" for sh1 it brings also item "hp" and when I select all and item "dell" it brings from sh3 without sh1 ,sorry I say that but the file is very confusing I no know how I explain the problem

first you should select the name of sheet from combobox the second write into textbox the value based on column b then filter data and show in listbox

ok this is the sample simple it's important instead of design more than one userform (purchase ,sales, returns) it occurs very heavy maybe some problems error if i have many userform every sheet contain process data purchase , sales, returns it's impossible to mixed process purchase and sales and returns in one sheet

I think this is different subject I have data into multiple sheets I would filtering by choose the sheet from combobox and textbox if my post is not clear I try explaining with another way to understand what I want

hello

I have this file populates data in listbox based on first sheet the textbox depend on column b , I added combobox contains the sheets' name so what I want when I select the sheet shows all of data relating selection sheet and when I write in textbox based on column b and based on selection sheet then gives data based on textbox moreover I would add to combobox the item "all" when I select the "all " populate all of data for all sheets and if I write in textbox based on column b bring the data for all sheets based on textbox and selection on combobox

thanks in advance

it's perfect

actually I put in module I no know where is the problem I tested thanks very much

what does mean this error invalid use me keyword ?

hello i have this code for Mr.Royuk and i amending by add the currency I would sum the formatting values with currency but it gives me error mismatch in this line

dTotal = CDbl(.TextBox1.Value) + CDbl(.TextBox2.Value)

Private Sub TextBox1_AfterUpdate()
TextBox1.Value = Format(TextBox1.Value, "$#,##0.00")
End Sub

Private Sub TextBox2_AfterUpdate()
TextBox2.Value = Format(TextBox2.Value, "$#,##0.00")
End Sub
Private Sub TextBox3_AfterUpdate()
TextBox3.Value = Format(TextBox3.Value, "$#,##0.00")
End Sub
Private Sub TextBox3_Change()

Dim dTotal As Integer
With Me
dTotal = CDbl(.TextBox1.Value) + CDbl(.TextBox2.Value)
Me.TextBox3.Value = Format(dTotal)
End With
End Sub

thanks Mumps for your time and your codes

god bless you

you're right but I note there is a problem , it copies data already are existed continuously after search

desWS.Range("A6:E" & LastRow).ClearContents

I put some result when search more than on time for different search in a2

my expected result in result1

the problem in result

hi, Mump I was trusting your code works finally works as what I say you don't believe me the problem is sheet in post 28 I use file search i insert a new sheet "result" to understand what's my problem surprisingly the I apply the code in sheet result and works astoundingly and i delete the sheet search and rename sheet result to search also works so well do you believe that but I ask myself how it is work for you without any problem you know this is the first time faces problem like this this problem caused headache

any way i have some requests if they're possible

1- I see this code is slow and I tested it gives me this value 0.680 is it normal if there is better I would appreciate

2- I would understand some parts of code about this line especially numbers

.Cells(.Rows.Count, "A").End(xlUp).Offset(1).Resize(, 5).Value = Array(srcWB.Name, fnd.Offset(, 1), fnd.Offset(, 2), fnd.Offset(, 3), ws.Name)

3 - 3 - I want when i search specific data it copies to bottom data has ever already searched IN in other words every time i search a new data then copies to under old data have ever already search i hope this point is clear