Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: newuser08
  • Content: Threads
  • Order by date
  1. newuser08

    Tighten up the code

    Hi guys, I've Tightened up the code to the best of my ability, any more suggestions speed things up? Private Sub btnNewData_Click() Dim xldcdata As Object Application.Calculation = xlCalculationManual frmworking.Show (0) DoEvents Set xlApp = CreateObject("Excel.Application") xlApp.Visible =...
  2. newuser08

    Locking VBA Project.

    Hi Guys, The workbook I’ve created has individual pages locked to the user (same password for each sheet), also I have locked the VBA Project. When I open the book I have made the sheets visible and unlocked them to save me time, however I also want the VBA Project to be unlocked. I have...
  3. newuser08

    MsgBox answer format

    Hi All, I’m putting together as seconds to minute’s converter and tried about 7 different variations that I’ve found (none of which seam to work for me). So far I have a inputbox asking the use to enter the totals number of seconds on Enter a Msgbox to show the result in minutes. Private Sub...
  4. newuser08

    holdagent = Sheet1.btnag6.Caption

    Hi all, I have a workbook with multiple sheets in it, what I am trying to accomplish is when I push a cmdbtn with a given users name as its caption the code will scan through all the worksheets select the range where = to the sheet1.cmdbtn.caption then paste a copy into a ‘results’ sheet. The...
  5. newuser08

    ActiveWorkbook.Sheets("TEST").Tab.ColorIndex = 3

    Not use where to start. Firstly can I say I ‘m a completed newb to excel vba so please go easy on me. In sheet1 I have a validation cell (A1 “Validation”) when True=1 else blank. I’m wanting to change the sheet tab colour to… err Red if Validation=1. Any suggestions… please try to keep them...
  6. newuser08

    Change Excels rounding threshold from .5 to .6

    I currently have to set up a calculator for some easy calculations - however here’s where I become unstuck. The normal laws of maths state that .5 you round up below .5 down. I need to change the threshold from .5 to .6. The results of the calculations are worked out to 3 decimal places so: A...
  7. newuser08

    Multiple user forms in excel

    Hi there I'm a new user to excel and just coming to terms with it. Here’s my question: Is it possible to have Multiple user forms in excel amending data in one xls worksheet? I have a book that contains a large amount of data that Multiple users (7) need to work on at the same time...

Part and Inventory Search

Back
Top