[Dba-office] Forms in Excel and Word

Hi all

This works (thanks Shamil).

But am I right, these forms are quite limited compared to Access forms regarding layout options?

I can set the border of the form, but that's an inside border - the form always has the standard Windows border outside which you cannot adjust or remove. I was looking for a borderless form design.

Also, buttons seem limited. These appear as of Office 97 style - no flat button, no border settings.

I'm using Excel 2013.

/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