Search Results - VBForums

Search:

Type: Posts; User: 3com

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    23
    Views
    330

    Re: Southern California Earthquakes

    Yeah, even there is one called Schwarzenegger :D
  2. Replies
    4
    Views
    130

    Re: Code help to search sheets in Excel

    I asked myself myself the same question.
    I can not find my crystal ball :D
  3. Replies
    23
    Views
    330

    Re: Southern California Earthquakes

    I agree. :)

    WATCH EARTHQUAKES IN 3D...

    http://www.wolton.net/quake.html
  4. Replies
    23
    Views
    330

    Re: Southern California Earthquakes

    Earthquake, uhmn...
    Like 2012 movie? :rolleyes:

    I was some ago time in San Diego, but the emigration police would not let me off the boat, so I only know the seaport. :mad:
  5. Replies
    4
    Views
    130

    Re: Code help to search sheets in Excel

    Sub SearchWord()
    Dim strWord As String
    strWord = "The value you are looking for"
    Dim sh As Worksheet
    Dim rng As Range
    Dim c

    For Each sh In ActiveWorkbook.Worksheets
    ...
  6. Replies
    20
    Views
    263

    Re: Filename problem when saving to new directory

    The trick is let this task for last moment.
    You do the work as normal (with Intellisense included), and when you finish the job, then you delete all references, and so on...
  7. Re: VB.Net VSTO for Excel Timer Event locks up Excel

    pseudo-code (not real code, only for illustrate idea purpose)



    Dim arrDL() as variant ' Public array variable to store found files (if any), thus it can be accessed by any procedure.

    private...
  8. Re: VB.Net VSTO for Excel Timer Event locks up Excel

    Why not ...?

    From vb.net.
    1 - Run the ftp monitoring.
    2 - If a new file exist, save the url of the file in an array.
    3 - Close monitoring.
    4 - Run the macro in excel and you pass the array to...
  9. View Post

    It looks as you've a clipboard object issue.

    http://www.vbforums.com/showthread.php?585616-clipboard-activex-for-vba-vbs-etc&goto=newpost

    HTH

    And Please, note that this is an English forum.
  10. Replies
    6
    Views
    230

    Re: user32 API Calls from VBA 7.1 in Word 2013

    Perhaps issue relate with PtrSafe, LongPtr , LongLong, and so on....
  11. Replies
    27
    Views
    460

    Re: Who am I?

    You are the photographer :)
  12. Re: Access report: switch printer and select tray before printing

    http://msdn.microsoft.com/en-us/library/office/ff193863%28v=office.15%29.aspx

    HTH
  13. Re: ComboBox DropDown List Event on Click

    Yes. Both work fine 4 me. :)
  14. Re: ComboBox DropDown List Event on Click

    @ TnTinMN
    Do you mean you was trying...


    Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As...
  15. Replies
    8
    Views
    151

    Re: Excel breaks to immediate window

    Bryce coming soon.... :)
  16. Replies
    8
    Views
    151

    Re: Excel breaks to immediate window

    This line of code only avoid the Excel being closed, after save file.



    I did that about 20 times without problems here. unfortunately do not have Excel 2010 for testing. Perhaps somebody with...
  17. Replies
    8
    Views
    151

    Re: Excel breaks to immediate window

    Then delete this line of code...
    Application.Quit


    I had tested your code in Excel 2007 and 32 bit. And it work fine for me, not inmediate windows coming.

    What's about my silly but necessary,...
  18. Replies
    22
    Views
    352

    Re: Need Outlook VBA Code - please help!

    As I said before not familiar with Outlook, anyway what I will do, well I'll try in a standard module, if not success, well try the other option.
  19. Replies
    8
    Views
    151

    Re: Excel breaks to immediate window

    I tried your code and it worked very well.
    A silly but necessary, question have you placed this code into ThisWorkbook module?, I know the code start with, but...
    And, are you sure you want to...
  20. Replies
    22
    Views
    352

    Re: Need Outlook VBA Code - please help!

    Not familiar with Outlook, for this reason I'm not sure whether this is that you are loking for, but googling out there I has found this code...

    Untested code.


    Dim WithEvents insp As...
  21. Re: Inconsistent Timer with GUI Library

    Glad you get solved.
    Please come back and mark thread as resolved.:)
  22. Re: Inconsistent Timer with GUI Library

    I have a form and a standard module.
    A textbox and commandbutton.
    NextButton changes their caption between "start" and "stop" depending on the state of the timer.
    When I press the NextButton the...
  23. Re: Inconsistent Timer with GUI Library

    Well here 23:18 pm, tomorrow has to work, well tomorrow I or any other user, take at look...
  24. Re: Inconsistent Timer with GUI Library

    Does "TimerModule.OnTimer" launch the application?
    If so, ¿how do you load form?
    Who call to "StopTimer_State" Sub ?, a commandbutton?
    And, do you want to close form when timer being stopped?
    ...
  25. Re: Inconsistent Timer with GUI Library

    Should I assume "TimerModule" as standard module, containing a sub called "OnTimer" ????
    If so, what that macro does?

    Related info... ...
  26. Re: Output to Excel in a format which allows sorting of alphanumeric?

    If you does not get fix it yet, Gary's Student post a good solution as follow...


    Sub Macro3()
    Dim rNumber As Range, N As Long
    Set rNumber = Nothing
    N = 20
    Range("A1:A" &...
  27. Re: Output to Excel in a format which allows sorting of alphanumeric?

    Try this one...

    http://www.ozgrid.com/VBA/sort-alphanumeric.htm
  28. Re: Output to Excel in a format which allows sorting of alphanumeric?

    And...?

    I get this from link above, as follow...



    Try formatting column involve as text, after that, run your macro, if it works, well we knows the cause, now we can think how we can format...
  29. Re: Output to Excel in a format which allows sorting of alphanumeric?

    http://support.microsoft.com/kb/322067/en-us

    HTH
  30. Re: Microsoft makes source code for MS-DOS and Word for Windows available to public

    112491

    http://www.viva64.com/en/b/0245/
  31. Re: Inconsistent Timer with GUI Library

    http://www.cpearson.com/excel/ontime.aspx
    HTH
  32. Replies
    3
    Views
    126

    Re: Type Mismatch error

    Just adding some relate info...
    http://support.microsoft.com/kb/983246/en-us
    HTH
  33. Re: Underlining text when using a checkbox

    Combine/adapt this code to yours, in order to suits your needs..


    Sub underline4me()
    'We require the results from wwwdotthisplacedotcom and must include all evidence.
    ...
  34. Re: Placing Text From A .txt File At The Cursor Position

    Dim NotesFilePath As String
    NotesFilePath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)

    Dim NoteRng As Range
    NoteRng =...
  35. Replies
    115
    Views
    1,745

    Re: Malaysia flight 370

    Specially reality show
  36. Replies
    3
    Views
    136

    Re: Excel Automation Weird Behavior?

    I think the problem and solution are not of the side of Excel.
    It's probably a matter of setting the local server.
    I guess your local server acts as Local Testing Server, if not possibly want to...
  37. Re: How To Prompt For Overwriting .txt Files

    ...Or if you prefer to keep all your notes for future reference, you can use something like....


    userNote = TextBox2.Text & vbcrlf 'or, Environment.NewLine

    Now you would get:



    If you...
  38. Replies
    115
    Views
    1,745

    Re: Malaysia flight 370

    From some media (read radio, newspapers or television) we can only get the official version of events, which does not always coincide with the truth.
  39. Replies
    3
    Views
    136

    Re: Excel Automation Weird Behavior?

    http://support.microsoft.com/kb/282830/en-us
  40. Re: Copy specific text in a textbox into specific places in other textboxes

    Both textboxes(TextboxA2+TextboxA3), are they enpty?
    In another words, you want to append text, or you want overwrite existing text (if any)?
Results 1 to 40 of 232
Page 1 of 6 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.