[Dba-office] Forms in Excel and Word

Hi Shamil

Thanks, exactly what I was looking for.

And Susan, the form will not contain data so the unbound nature is no issue.

/gustav


-----Oprindelig meddelelse-----
Fra: dba-office-bounces at databaseadvisors.com [mailto:dba-office-bounces at databaseadvisors.com] På vegne af Salakhetdinov Shamil
Sendt: 3. februar 2015 08:06
Til: dba-office at databaseadvisors.com
Emne: Re: [Dba-office] Forms in Excel and Word

 Hi Gustav --

Yes, you can create UserForm objects, They are always unbound. They have slightly different set of controls than MS Access but programming them doesn't differ that much from programming MS Access unbound forms. And you can use WithEvents if you need to program a set of forms with similar generic manual data retrieving/binding/persisting/searching. WIthEvents worked in MS Excel better than in MS Access.

Here is a link on one sample UserForm: http://www.excel-easy.com/vba/userform.html

-- Shamil


Monday, February 02, 2015 7:37 PM UTC from Gustav Brock <gustav at cactus.dk>:
>Hi all
>
>Can you create an unbound form in Excel/Word similar to an Access form?
>I've never done this. It will have no data access - just a popup type of form.
>
>Any example to download to not reinvent the wheel?
>
>/gustav