Mr. DKT thank you so much for sharing your esteem knowledge about the Excel and the VBA. Your videos have thought me lot.
@Exceltrainingvideos
4 жыл бұрын
Great to hear!
@chuckwilcox6997
7 жыл бұрын
Always a great presentation, very well explained. Its just the code I need for this morning that I was I was going to do today, great timing :) Thank you for sharing your knowledge.
@jeanyveslaval4293
7 жыл бұрын
thank you for this video i learn so much as this help me at work in saving time have you a video on working with active sheet purchase orders and copy the current range to a specified directory as a database without opening it and not overwriting existing data in that database as headers are same in active sheet and database. otherwise need to copy and paste manually,
@helmybinmadi5776
7 жыл бұрын
great knowledge learned :). thanks and all the best
@sivaseeta5413
7 жыл бұрын
hi...i would like to know how to automatic looping between two tables. for example if a increase, b and c automatically reduces or increases depends on the value given. i am looking at basic smart app.
@Exceltrainingvideos
7 жыл бұрын
What have you tried? You may also like to search www.exceltrainingvideos.com
@poojatawale8902
7 жыл бұрын
thank you sir
@binukdly3654
5 жыл бұрын
Sir, good afternoon. I need a help. I think this query is not a disturbance for you. I have two textboxes in my user form. There is a data range 1 to 1000 rows . In range a1 to a1000 some product code like e0001 to e1000. My requirement is If I put e0001 in first textbook and 100 to the second textbox2 and click a c.botton then need to select the last blank column and paste the value 100 to that cell. This process to be done all the 1000 road. Pls. Give a help for this. Thanking you Binu
@Exceltrainingvideos
4 жыл бұрын
This link will guide: www.exceltrainingvideos.com/ensure-all-data-fields-in-userform-filled-before-transfer-to-excel-worksheet-using-vba/ Or search www.exceltrainingvideos.com
@LynXify
7 жыл бұрын
I have a very minor issue but it's taking a long time to solve. I would appreciate your help regarding it. I am connecting to an SQL Database and running a stored procedure. I am then getting the result in a Record Set variable and I can print the output using Debug.Print rs.Fields(0).Value However, I wish to print this value on the excel cell on which I am calling this VBA Function I have tried so many things ranging from ActiveCell.Value to Sheet().Range().Value to Worksheet().Range().Value to Cells() Nothing seems to work. Can you please help.
@gokhan5924
7 жыл бұрын
Sir can u look facebook ? I have an emergency question.. Pls help
Пікірлер: 13