Results 1 to 10 of 12

Thread: get an error if i press calculate-1 button without entries in the 4 Labels in Red

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jul 2013
    Posts
    102
    Rep Power
    13

    get an error if i press calculate-1 button without entries in the 4 Labels in Red

    How do i change code in the userform so that i must have entries in the following Textboxs which are Red in colour on the Userform....i get an error if i hit the Calculate-1 button without entries in these 4 textbox`s
    System Feed Flow
    Feed Concentration
    Outlet Concentration
    CT Feed Flow

    Also how do i make the results show as whole numbers?

    Also can the colour of the numbers in the result box`s be Blue?

    Still new to VBA code so i have i made this coding correct...it does work though

    Best Regards

    Jeff
    Attached Files Attached Files

Similar Threads

  1. adding entries into combobox with code
    By paul_pearson in forum Excel Help
    Replies: 1
    Last Post: 07-23-2013, 01:01 PM
  2. Macro To Calculate Percentage Allocation
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 06-01-2013, 01:59 PM
  3. Replies: 2
    Last Post: 05-26-2013, 03:41 PM
  4. Red Green Amber Three Color Conditional Format
    By paul_pearson in forum Excel Help
    Replies: 1
    Last Post: 03-07-2013, 06:50 PM
  5. Calculate the Hours
    By leopaulc in forum Excel Help
    Replies: 2
    Last Post: 02-27-2013, 02:51 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
  •