Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~404 People Reached
Favorite Forums
Favorite Tags
Member Avatar for claw72

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 …

Member Avatar for claw72
0
106
Member Avatar for claw72

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 …

Member Avatar for AndreRet
0
176
Member Avatar for claw72

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 …

Member Avatar for AndreRet
0
122