Search results

Glad to help,thanks for the feedback :)

Private Sub LB_00_Click() For i = 0 To 9 Me("T_0" & i) = LB_00.Column(i) Next For i = 10 To 11 Me("T_" & i) = LB_00.Column(i) Next End Sub Give your texxboxes, simple names like T_00 , T_01 and so on In this example the listbox is named LB_00

Sure I made a table from your sheet (with the name newdata_tbl) I changed your textboxes to T_00 ,T_01 en T_02 and your listbox to Lb_00 (then is easy to use them in a loop,as you can see in the lisbox (Lb_00) click event. Click in the listbox and see what happens. I forgot to tell, a listbox...

@ antonio,welcome to Chandoo. please use code tags if you post code. Click the 3 dot and use </> to put your code between code tags.

Does this help? see green cells

Example.

=(D6*9)-5

Hi, try thiss code. Private Sub CommandButton1_Click() Dim lrow_v As Long With Sheets("NEW DATA") lrow = .Cells.Find(What:="*", SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1 .Cells(lrow, 1).Resize(, 3).Value = Array(TextBox1.Value, TextBox2.Value...

Glad to help., an.d thanks for the feed back:)

Show how ,you are still living in la la land

Like this, enter the ammount without currencysymbol en press enter or tab

Like this? enter ammount without currency symbol and push test.

Glad to help :)

Private Sub cmdDelete_Click() Set ws = Worksheets("Items") Set Rng = [SK] Set fnd = Rng.Find(What:=ListView1.SelectedItem, LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=True) ws.Rows(fnd.Row).Delete End Sub Make a defined name range (first column in your Listview) in Formulas -> Name manager...

@Fred Wayne , I have a few options to sort a listbox, not a listview, I never use it. See a small example

Is your problem solved?

That is wat I ment with As my native language is not english using the word table was not ideal.

Why don't you sort your table it wil reflect in listview?

They are working on it, there should be a solution in a few days.

Cross post on a Dutch site with a solution made by a good friend of mine. https://www.piepcomp.nl/threads/exel-regel-terug-plaatsen-na-update.12370/#post-118073

Thanks for the feedback. :)

As attachment example with 5 userforms (working) If you change the sheet names then you have to change that in the code of the forms, thats all. For the rest, you can change column headers in the tables and label captions in the forms or the buttons captions in the entry sheet or the titels of...

Yes you can have multiple forms in the same workbook but the they have to have a different name. an easy way to do this, open a new excelfile, drag that form to the new excelfile, tername the form and drag the form with the new name back to your workbook. (then you can delete the new file) There...

Yes, it is a table and a table is dynamic. That is possible, in the vba editor drag the userform to another file and copy the data sheet to the this file. Then you can change the names of the column headers and the labels in the form. Anyway we are here to help you.

LIke this?