Search:

Type: Posts; User: Colo; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    2
    Views
    96

    Re: Network User Login Information in Footer

    chadders, from AD on Windows server network? In that case, using API helps. Just wanna know what does"user ID" exactly means. "User Name" or "UID" for UNIX?
  2. Thread: Round KO by VBA

    by Colo
    Replies
    3
    Views
    164

    Re: Round KO by VBA

    Tia, Round in VBA returns an even number that is called "bankers' rounding", C# as well. If you need the same result as on a worksheet, try "WorksheetFunction.Round" instead.
  3. Re: Looping Through, and sorting the contents of Named Ranges

    Hi TurningFinal,
    First, good job! I think that it's almost done. All you have to do is that making the uncommented code part as a sub routine then call it from the main routine. I have no data for...
  4. Replies
    2
    Views
    133

    Re: Comment move after sorting, help

    Patthe, why don't you move those comments by a macro? The following code works like "resetting" the location of comments on the worksheet.




    Sub MoveComments()
    Const coef As Long = 5
    ...
  5. Replies
    1
    Views
    352

    Re: Best VBA Alternative to Locking a Worksheet?

    it's just my idea but why don't you make it an addin so that they cannot touch worksheet? ;-)
  6. Re: Excel 2003, question about jpeg's in comments...

    Save as an html file so that all the image files are also save in a folder.
  7. Re: Need help adding a pivot table to a new sheet using vba

    Hi frank1107,

    An argument used for DefaultVersion seems to be xlPivotTableVersion10. No need to add "new" I guess.
  8. Replies
    4
    Views
    311

    Re: Application.Displayalerts not working...

    Hi rbon,

    To disable hyperlink warning messages, need to follow as follows.
    How to disable hyperlink warning messages in Office 2003
  9. Re: Shortcut Key: Possible to use the Windows Key instead of the CTRL

    Hi Martin. As far as I know, it's impossible. WINDOWS key works as same as when we press Ctrl + Esc.
    Shortcut Key can be set by VBA using Application.OnKey, so the code would be as follows, but it...
  10. Replies
    1
    Views
    314

    Re: The world's most tricky macro.

    Hello world! :-)

    My answer is premised on your programming experience in VB.NET. Using VB.NET, all the files in the specific folder can get with System.IO.Directory.GetFiles.



    Dim files As...
  11. Replies
    6
    Views
    604

    Re: excel macro execution speed (run time)

    So, sounds like a problem from Windows 8 networking. Better ask this at other message board for Windows users not for Excel users. Anyway, not sure if it works but trying is free.

    How about...
  12. Replies
    6
    Views
    604

    Re: excel macro execution speed (run time)

    Hi RAYLWARD102 I've seen the same problem on the Microsoft Japan community. When he uses Windows 7 32 bit and Access 2010 32 bit runtime, no problem about its speed, but on Windows 8 64 bit and...
  13. Thread: Copy Worksheets

    by Colo
    Replies
    2
    Views
    195

    Re: Copy Worksheets

    Hi Papi,

    I think that u need to get the latest # from the exiting workshees first.



    Sub Copy_Sheets_colo()
    Const sCurshName As String = "Report"
    Dim lLastNum As Long
    Dim...
  14. Replies
    2
    Views
    1,793

    Re: Drop Down List Font Size Workaround

    Hello nirvehex,

    I've seen same questions but as far as I know, there is no way to increase the font size of in a drop down. All waht i know is that zoom the worksheet 200% then make all the font...
  15. Replies
    2
    Views
    185

    Re: Quick Looping userform Question

    Hi braindiesel,

    Yes, you can use a loop as follows.



    Dim i As Long
    For i = 1 To 15
    If Me.Controls("TextBox" & i).Value = "" Then
    NewRowFormulas
  16. Re: Cant load my user form - Subscript out of range

    Hi MCE2014,

    I'm sure that posted code doesn't have any problem. A code line in the form frmDefects has an error and it's a runtime error so it occur when the procedure is executed. Please check...
  17. Replies
    1
    Views
    537

    Re: Userform Data Validation

    Hi bethaneesmith, welcome to the forum. To check the strings, using Regular Expression is handy as follows.



    Private Sub TextBox1_Change()
    Dim oReg As Object
    Set oReg =...
  18. Re: creating new shape and opening hyperlink dialog

    Hi jjnelson81,

    Hyperlink dialog can be opened as follows.


    On Error Resume Next
    Application.Dialogs(xlDialogInsertHyperlink).Show


    To let user to select hyperlink destination, after...
  19. Replies
    10
    Views
    1,254

    Re: Popup if value in range is less than 5%

    Okay, anyway the "calculate" event seems to be working. Remove the second On error resume next part then check why it gives you an error. The second IF part was written by my guess because I cannot...
  20. Replies
    10
    Views
    1,254

    Re: Popup if value in range is less than 5%

    Ah okay, try like this.




    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim myTarget As Range
    On Error Resume Next
    Set myTarget = Intersect(Target.Dependents,...
  21. Re: How to convert a list to a table by a single field

    Hi jumpulas,

    I wrote some advices in the following code line.
    Please have a look at those and give it a try.



    Sub test2()
    Dim shData As Worksheet, shRes As Worksheet
    Dim rEmployee...
  22. Replies
    10
    Views
    1,254

    Re: Popup if value in range is less than 5%

    About that part, I just guessed because I had no idea what kind of data and formulas are on the worksheet. So it needs to be fixed to suit to your worksheet.
    Easy solution would be adding an error...
  23. Replies
    10
    Views
    1,254

    Re: Popup if value in range is less than 5%

    As an event driven, Change event runs when a value of cells are changed, but it doesn't run by the change from calculation. Instead of the Change event, Calculate event can be used like you tried but...
  24. Re: How to convert a list to a table by a single field

    Here is another solution using VBA.



    Sub test()
    Dim shData As Worksheet, shRes As Worksheet
    Dim rEmployee As Range, rProject As Range
    Dim i As Long, x As Long, y As Long

    ...
  25. Replies
    23
    Views
    2,120

    Re: Your name in "Japanese"

    No worries Leandroarb ;-) I just looked at the CODE part.
    Thanks anyway.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4