+ Reply to Thread
Results 1 to 2 of 2

write userform data to cell based on column header

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    write userform data to cell based on column header

    I've got a question about writing data to cells in a spreadsheet.

    While I can locate the row I need to input data in a Sheet, and then copy the data by stipulating the letter head of the column (eg. Column A, Column B, etc), is there anyway to write the data based on the column header (the value that I put in the first row.

    My current code is as follows:

    Please Login or Register  to view this content.
    In the Sheet, the first row of column K is marked as obuPreChangeSubmit
    the first row of column L is marked as cboPreChangeMetricBlocks
    etc.

    Ideally, instead of identifying the particular cell based on the column letter, and then writing the data to that cell, can I identify the column based on the data in the first row?

    eg. instead of:
    Please Login or Register  to view this content.
    something like:
    Please Login or Register  to view this content.
    Hope this makes sense and that someone can help!

    Thanks

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: write userform data to cell based on column header

    Cross-post http://www.ozgrid.com/forum/showthread.php?t=169753

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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