calculation and forms


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: calculation and forms

  1. #1
    Join Date
    Aug 2005
    Posts
    2

    Angry calculation and forms

    i have a form in which the following is used
    'Private Sub tbxSellPrice1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

    'tbxSellPrice1.Value = tbxNetCost1.Value * 2
    'End Sub
    i would like to be able to replace "2" with a value stored in say worksheet5 cell A2
    can any one suggest how this can be achieved

  2. #2
    Join Date
    Feb 2004
    Location
    Colton, CA
    Posts
    550
    Code:
        Sheets("Sheet5").Select
        Range("A2").Select
        a = ActiveCell.Value
    then replace the 2 with a

  3. #3
    Join Date
    Aug 2005
    Posts
    2

    Red face

    works ok for me ,
    thank you for a quick responce

Similar Threads

  1. Remove exchange from a site
    By andriano in forum Enterprise
    Replies: 1
    Last Post: 10-02-2000, 03:54 PM
  2. Working with Forms and Calculations
    By David in forum Java
    Replies: 0
    Last Post: 05-02-2000, 01:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center