How to create Excel VBA Master Detail forms using Virtual Forms

preview_player
Показать описание
How to create Excel VBA Master Detail forms using Virtual Forms with just a few lines of VBA code.
In this video, we use Excel VBA as the frontend and the MySQL database as the backend.

Find out more here:
Рекомендации по теме
Комментарии
Автор

I need a help for the below. I have created a drop down list in excel containing 3 text. 1.Prior term 2.Quote 3.summary.

All in cell B2.

So,

When I select 1.Prior term,

I don’t want to allow typing the word “Quote” and “summary” in Coloum C in excel.

When I select 2.Quote,

I don’t want to allow the text “prior term” and summary in coloum C.

How can I do this with VBA.I know only a very little about VBA.Can anyone help in this regard.

join shbcf.ru