vog

Hi Everyone, Happy New year to all Great ones. Please help in achieving my task, I have tried to some macros and some vba code to do some work in this workbook, actually I have prepared this excel for stock and inventory management as per our requirement. In this workbook user can do following...

if checkbox1.value = true then i select combobox2 value (for example 01/02/2015) then give the value in textbox value= 100 then click the commandbutton i need the output value for the entire column from B2 to B5 = 100. can anyone give the solution. <tbody></tbody> <tbody> 01/02/2015...

So above is my worksheet that I'm currently working at. My problem is I want to automatically move D7:AM7 only (from the column of "Date arrived" to the very last "1X1" in the illustration) to sheet2 if A1 ("Status" column) would have a USED word in it. And after D7:AM7 would be cleared and be...

Hello all i want a coding on button to select the cell value only and copy that. please find below example <tbody> A B C D E 1 Rahul on 08/09/2013 _____ 2 </tbody> i want to create button on B1 that i know how can we create button. but i want when i click on that button it will...

VoG, I have a macro you supplied in a different thread: Sub InsRow() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = LR To 2 Step -1 If Range("A" & i).Value <> Range("A" & i - 1).Value Then Rows(i).Insert Next i End Sub However, this is inserting a row ABOVE...

hello Guru my boss wants to have a reminder tool for air ticket and accomodation that can popup the reminder message 3 days before the due date and atlest two times a day. the excel workbook has two sheets the reminder has to be set in the second sheet which has ten columns as showns below. i...

I find your posts very helpful in beginning to understand VBA. I cannot return the gift you have extended here, so I will Just say, Thank You.