Results 1 to 17 of 17

Capture data from OptionBox into datasheet

Threaded View

  1. 08-21-2013, 06:18 PM #15
    Daniel B
    Daniel B is offline
    Registered User
    Join Date
    07-30-2013
    Location
    England
    MS-Off Ver
    Excel 2003, Excel 2010
    Posts
    13

    Re: Capture data from OptionBox into datasheet

    Quote Originally Posted by XeRo Solus View Post
    So if I click the Unit A button it will say Unit A in AL1?

    Next time I click Unit C button it will say Unit C in AL2?
    No. When all data from user form gets filled in, than after clicking submit it will paste it all in the next empty Row. so Unit will be in AL8 and shift in AM8.
    Last edited by Daniel B; 08-21-2013 at 08:25 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return data to datasheet when checkbox in the form is checked
    By Apple Ling in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2013, 02:09 AM
  2. need help to get data from datasheet on to the userform
    By shankar.nstl in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-04-2011, 06:12 AM
  3. how to update data from one datasheet to a master sheet, automatically
    By mikej2009 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-31-2010, 11:09 PM
  4. populate 'form' from datasheet - how to select next data
    By Chaka in forum Excel General
    Replies: 2
    Last Post: 02-19-2010, 02:59 AM
  5. Saving data to a form datasheet
    By University of Maine student in forum Excel General
    Replies: 0
    Last Post: 03-14-2006, 04:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1