+ Reply to Thread
Results 1 to 5 of 5

How can I create a mask (Userform) to insert data?

  1. #1
    Registered User
    Join Date
    08-17-2013
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    2

    How can I create a mask (Userform) to insert data?

    Hello,

    I have a simple table with these column: Name, Surname, Address, Date of Birth, etc.

    I would like to create a button which open a mask to insert the above data automatically in the table, without scrolling up and down in it.

    I tried playing, being able to create the mask, but it doesn't work, the final command "OK" doesn't insert the data. I am sure it is a stupid thing, but I can't sort it out.

    Could you please help me step-by-step?

    (I have then another question about the export of the data to a word document in a specific "form", but it is another story...)

    Thanks!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,212
    Where is the table located and how is it organised?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-17-2013
    Location
    Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How can I create a mask (Userform) to insert data?

    Quote Originally Posted by Norie View Post
    Where is the table located and how is it organised?
    i hereto attach the table, if i understand correctly your question: userform_1.xlsx

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,212

    Re: How can I create a mask (Userform) to insert data?

    It should be straightforward to write the data from the userform to the table, what have you tried?

    Also, what do you mean by a 'mask' exactly?

  5. #5
    Forum Contributor
    Join Date
    04-15-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2016 / Office 365
    Posts
    115

    Re: How can I create a mask (Userform) to insert data?

    Here you go try this. There is room on the form for additional fields.
    Attached Files Attached Files
    Last edited by jrtraylor; 08-17-2013 at 07:18 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to create a date mask and drop down list?
    By Nikos in forum Excel General
    Replies: 6
    Last Post: 08-05-2006, 01:30 PM
  2. [SOLVED] create a text mask
    By bryanp354 in forum Excel General
    Replies: 4
    Last Post: 07-26-2006, 01:35 PM
  3. insert elemnts from cells into array, create a userform with values checkboxes
    By usadream in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2006, 11:30 AM
  4. Create a mask inside a textbox
    By dok112 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2005, 08:05 PM
  5. how do I create a data entry edit mask?
    By Jeff Perreault in forum Excel General
    Replies: 0
    Last Post: 06-10-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1