Results 1 to 2 of 2

VBA code Data Form - VBA generated

Threaded 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

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