Results 1 to 7 of 7

A question regarding

Threaded View

jobro A question regarding forms 04-23-2008, 04:27 AM
royUK Welcome to the Forum. You... 04-23-2008, 04:50 AM
jobro Thanks, I'm on quite a... 04-23-2008, 05:09 AM
royUK Which version of Excel are... 04-23-2008, 07:35 AM
jobro I'm using Excel 2003. No... 04-23-2008, 08:39 AM
  1. #1
    Registered User
    Join Date
    04-23-2008
    Posts
    10

    A question regarding forms

    So we're working on a pricelist that gives the end user a very easy way to lookup prices on the fly and get the money a customer needs to pay. So on sheet 1 we've got the items and the prices in their respective columns.

    There is an userform aswell. In that form I've got a list linked to a the item names. That much is easy done. Now I've got in the same form a textbox that needs to be updated with the correct item chosen.

    For this I've used the following code:
    Me.Vara2.Text = Cells(lCrow + Vara1.ListIndex, 5).Value
    that does give me an error that I'm using Me faulty.

    Check the attachment xls file for more information.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by jobro; 04-23-2008 at 05:28 AM. Reason: Setting things straight what I need help with.

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