+ Reply to Thread
Results 1 to 2 of 2

VBA code Data Form - VBA generated

Hybrid View

  1. #1
    Registered User
    Join Date
    03-29-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2007
    Posts
    1

    VBA code Data Form - VBA generated

    Hi all,

    I'm working for a small company and I have an Excel dataform with more than 32 columns (therefore the add-in is not possible).
    I would like to have a clearer overview. Therefore I want to display the data as a dataform.

    The enhanced dataform of John Walkenbach is not what I want.
    - I don't need the buttons to change rows
    - I prefer a small button at the beginning of the row with 'oper or display this row as a dataform'
    - It is really important that the changes save if I press Enter
    - Change the cells -> also the cells that contain formulas (I want to change the formula)
    - I prefer not to scroll, thus (like in the attachement) I prefer to display the data in two columns

    Does anyone know (all of this, what a demands haha) if this is possible or is there a vba code available for this?
    I have some experience with programming, maybe it is possible to change the John Walkenbach code for this?

    Thanks.

    Jette
    Attached Images Attached Images

  2. #2
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: VBA code Data Form - VBA generated

    In the vba editor make the desired form. Write code to load the data into the form, and code to save the data to the worksheet.
    Done!
    To do it for me and help me it is 2 different things!
    Sorry for my english, blame Google translator

+ 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. pull data from generated form
    By damiancds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2016, 07:09 AM
  2. code needed to copy cell data to a newly generated tab
    By renrenren in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-14-2013, 09:26 AM
  3. Dynamically Generated Form And Their Click Events
    By fenilbhoot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2013, 10:13 AM
  4. Rather than Excel form to data, can code be wriiten to take data into a form?
    By finlain in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2013, 12:23 PM
  5. Code to scrape system generated outlook email doesn't get all the data
    By bobaftt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2010, 01:57 PM
  6. Form of an automatically generated number
    By ImboJones in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2010, 09:35 AM
  7. Get textbox value from custom/dynamically generated form
    By sonyidicula in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-16-2010, 08:52 AM

Tags for this Thread

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