View original (French)

EXCEL MAC Creating a USERFORM

PimG -  
 PimG -
Hello,

I am a beginner in VBA and what makes things worse is that I have the latest version of Excel for Mac.
I want to create a dynamic form, however, unlike the 2011 version of Mac, there is no form icon in the "Data" tab. So I don't know where to go to create my Userform.
Your help would be greatly appreciated.
Thank you in advance for your responses.

Configuration: Mac OS X (10.10.5) / Safari 9.0.3

1 réponse

Réponse 1 / 1
f894009 Posted messages 17417 Registration date   Status Membre Last intervention   1 717
 
Hello,

"Data ---> Form" excel2004 not 2011
"Data ---> Grid" for 2011

A form is not a Userform

What exactly do you want to do??
0
PimG
 
Hello,
This is indeed a Userform I want to create.
I would like to create a dialog box to fill a database, like what can be done on ACCESS.
0
f894009 Posted messages 17417 Registration date   Status Membre Last intervention   1 717 > PimG
 
Hello,

To see

https://www.techonthenet.com/excel/macros/visual_basic_editor2011.php
0
PimG > f894009 Posted messages 17417 Registration date   Status Membre Last intervention  
 
Thank you.
I will try to see if I can do it with your link.
I looked around on all the forums and tutorials, and it seems that it is not feasible for now with the 2016 version.
0