No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
hi people can anyone help me how to simplify these codes? [CODE]Set oExcel = CreateObject("Excel.Application") Set oBook = ThisWorkbook Set osheet3 = oBook.Worksheets("DBASE") Set osheet4 = oBook.Worksheets("List Box Lookup Demonstration") Dim listIndex As Variant On Error Resume Next osheet3.Select Range("b65536").End(xlUp).Offset(1, 0).Select Selection.Value = ListBox2.List(0) Selection.Offset(0, -1).Value = TextBox2.Text Selection.Offset(0, 1).Value … |
|
Hello everyone. i really need help on this one.. sorry for bad english! I have made 2 listbox.. listbox1 and listbox2. data on listbox 2 comes every after i double click listbox1 data. my codes for that works properly. i am working in a excel worksheet. i have these columns … |
|
hi.. as a new member, i am very excited to hear from experts for opinions/coaching/teaching which will be very relevant to what i am currently doing and will be doing in the future. i find this community very helpful to me. i have made a lot of searches for my … |