+ Reply to Thread
Results 1 to 2 of 2

VB codes for delete command button (new)

  1. #1
    Registered User
    Join Date

    VB codes for delete command button (new)

    Will you please help me with the following:

    I have created a form in excel for entering information in a particular sheet. All my entering of data, navigation through the rows are strictly done only through this form. I need codes for a delete command button for my form. Suppose I have entered about 15 rows of data. ie each row has information in Columns A to M (say). All the column headings are given as fields in the form. If I find that the second row of data that I entered is not needed. Then after retrieving the data pertaining to the second row when I press the delete command button, all the information entered in the second row should be wiped out and the subsequent row's information gets shifted up. No row should be left empty in my worksheet after deleting the information in that row.
    This can be compared to deleting a record set in Ms Access using the VB form. But the only difference is that here the back end is Ms excel.Is this possible or just "clear" and "edit" command buttons will do this job?


  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    Melbourne, Australia
    Please post your question in the correct forum & read forum rules - see blue link below

    closing post
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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