Excellent Sir

@Exceltrainingvideos

2 жыл бұрын

Keep watching

Dear Sir many thanks for teaching step by step slowing and explainging each step

Great tutorial 👌 Thank you very much!!

@Exceltrainingvideos

2 жыл бұрын

Glad it was helpful!

This is really brilliant & thanks

@Exceltrainingvideos

2 жыл бұрын

Most welcome 😊

Sir i want to have many sheets & these sheets names should add to listbox in userform then specific cells value should display infront of each sheet names on listbox.

Is there any way to send excel data into Matchcad using VBA. I have many claculation work on mathcad but I want excel to be use as an input body which send the specific cell data to a variable in mathcad and the mathcad run the calculation. after that vba send the message to print the mathcad worksheet Example is here to understand Step 1: In excel sheet, we have let say a=3 b=5 c=9 and so on (actually I have more than 100 values) Step 2 Excel vba open mathcad using COM or API (I do not know the code yet and how to open mathcad from excel vba) Step 3 Excel sent a, b, and c value in mathcad where many operation are performed such addition, square and many more, These reults are available in mathcad Step 4 Excel send signal to print mathcad and then close the mathcad worksheet. Note: Please note the actual work is much more complicated it has atlead 30 pages of calculation in mathcad and more than 100 variables need to be sent from excel to mathcad using VBA. Each time I performed the calcualtion, these 100 values are different every time. Right now I put these values manually that takes time and may have errors Is there any solution available like I mentioned in four steps? Thanks in adance

Thank you for tbis great video 📹. Could u have also used the calculate event for this ?

@Exceltrainingvideos

2 жыл бұрын

Did you try it out?

Sir thank you so much It's really interesting and useful 👌 But sir usually customer pay single invoice several times than ? Instead of columns if insert part in rows I think will be solved. Can you please help me. Thanks sir My regards

@Exceltrainingvideos

2 жыл бұрын

I gave you the solution! Of course, you can enter the data in rows by just swapping row-index and column-index in the loop.

thank you sir. is there any book for VBA in online to purchase sir?

@TECHVETS

2 жыл бұрын

🙏

@Exceltrainingvideos

2 жыл бұрын

www.exceltrainingvideos.com/resources/

@TECHVETS

2 жыл бұрын

@@Exceltrainingvideos thank u very much sir

Dinesh if you have e-mail? I have two questions asking to you.

@Exceltrainingvideos

2 жыл бұрын

takyardinesh@gmail.com

ho