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!

  • Congratulations TouchToneTommy 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: bdc138
  • Content: Threads
  • Order by date
  1. bdc138

    System.Windows.Forms.DLL Error May be cause by Microsoft Update

    I am having some issues with Visual Basic 6.0 and Visual Basic NET. A recent Microsoft Windows update (Microsoft.NET Framework 2.0: x86 (KB829019)) which became available in late January was installed a few of our computers. This update seems to have caused a conflict in some system DLL's...
  2. bdc138

    Sending Key Strokes to Non-Windows Based Programs

    I'm trying to send key strokes to a DOS based program using VB6 but the SendKey syntax won't work. Does anyone know a way around this? Thanks.
  3. bdc138

    Formatting Data

    Hello, I have a ton data in a comma delimited txt file like shown below "Orig Format" I'm trying to convert it to a list of 6 digit numbers with spaces for missing numbers. At the end of each set, I need to place ascending numbers in place of ,, which need the format _ _ _ . Any help would...
  4. bdc138

    Microsoft Excel: CountIf Syntax

    Hi, Here is the basic idea. I have a column of boolean excel data that returns 'Y' or 'N'. (i.e. =IF(G2>=10,"Y","N")) I would like to create a new column that counts the cells where the value that is returned is equal to 'Y'. The range however is not the entire column...
  5. bdc138

    Pocket Excel: Creating Drop Down Lists

    Hi, I understand that Pocket Excel does not support data validation. Does anyone know an alternative method to create drop down lists that would be supported by Pocket Excel. Thanks, Brent
  6. bdc138

    Pocket Excel: Creating Drop Down Lists

    Hi, I understand that Pocket Excel does not support data validation. Does anyone know an alternative method to create drop down lists that would be supported by Pocket Excel. Thanks, Brent
  7. bdc138

    "Change" Worksheet Event Code

    This was my original post: Here is the basic idea.... A 7 N 8 9 10 11 12 The possible values to be entered are N,S,E,W. I want to create a formula that when A8 is highlighted it enters the appropriate value(N,S,E,W) into A8. In this case N. When A9 is highlighted it would automatically...
  8. bdc138

    How To Enter Worksheet Event Code

    In response to your reply on my thread.... http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/32/pid/707/qid/518169 How do you enter this worksheet event code? Thanks, Brent
  9. bdc138

    Excel: Automatic Field Entry

    Here is the basic idea.... A 7 N 8 9 10 11 12 The possible values to be entered are N,S,E,W. I want to create a formula that when A8 is highlighted it enters the appropriate value(N,S,E,W) into A8. In this case N. When A9 is highlighted it would automatically enter N. If the user were to...
  10. bdc138

    Moving columns of data into rows

    I'm working with a large workbook containing 24 sheets. I created a new worksheet with the following columns: A B C D E F G H I J K L M N Dir ID Spec 1.5m 0.3 .05m 5m 3m Tall BT I need to extract data from the current worksheets("Sheet1&quot...

Part and Inventory Search

Back
Top