Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    2
    Views
    67

    for loop question

    Hi
    I made a spelling mistake in the code below but still working fine.
    the currentpostion in the loop

    For x = currentpostion To Len(phrase)
    is wrong spelling. I stepped in the code and it is...
  2. Replies
    2
    Views
    133

    Extract Numerical Portion of String

    Hi
    I am trying to understand the code below. I have 2 questions now

    1) What is the idea of using Mid() function
    2) What does &amp mean.

    Temp=Temp&Mid(Phrase,Current_Pos,1)
  3. Replies
    13
    Views
    386

    Re: Dim Cell. no "as"

    Thanks all for your help. I inserted button. I changed the argument to String but then when I right clicked on the button to assign macro, I do not see any macro. Then I removed the argument from the...
  4. Replies
    13
    Views
    386

    Re: Dim Cell. no "as"

    Sorry another question. How to call that sub?
    I create a button in my excel sheet and tried to "Assign" to macro but the macro was not in the list!
    Another thing, I just noticed that this macro has...
  5. Replies
    13
    Views
    386

    Dim Cell. no "as"

    Hi
    I would appreciate if you can help me understand the code below
    1) What does Dim Cell mean? why "as" was omitted
    2) What does "&gt" do here?
    3) Is these easier implementation of similar code?...
  6. Replies
    3
    Views
    87

    Re: adding 2 numbers - userform

    Thank you. Val working better
  7. Replies
    3
    Views
    87

    adding 2 numbers - userform

    Hi
    I have userform which has 3 text boxes. I want to add 2 numbers and put the result in the 3 box when I click on + command button. Everything is working fine but if I only entered one number in...
  8. Replies
    2
    Views
    420

    job description questions

    Hi

    Sorry if this off topics. I am reading the job description below. I would appreciate if you can answer my questions just to get an idea what is the requirement and where I am at.


    1)...
  9. Thread: Cancel = true

    by lezawang
    Replies
    3
    Views
    104

    Re: Cancel = true

    Yes I did actually and it is working but to be honest, it does not make sense. That is why I wanted to confirm. Thank you
  10. Thread: Cancel = true

    by lezawang
    Replies
    3
    Views
    104

    Cancel = true

    Hi I have a form which has 2 text boxes, one for userName and one for password and 2 buttons, one Enter and one Cancel. The article below is saying I need to make Cancel properties of a command...
  11. Thread: With-End With

    by lezawang
    Replies
    3
    Views
    108

    Re: With-End With

    The error message, compiler error function value. Yes it works without = sign. Thank you so much.
  12. Thread: With-End With

    by lezawang
    Replies
    3
    Views
    108

    With-End With

    Hi
    I have "dept" as ListBox and I am trying to initialize it using With-End With but I got compiler error. Thank you so much.


    Private Sub UserForm_Initialize()
    With dept
    .AddItem...
  13. Replies
    3
    Views
    122

    Re: improving userform

    Thank you for your help. I got compiler error. Is it Excel_Click= true or Excel.value=True?
  14. Replies
    3
    Views
    122

    improving userform

    Hi
    I have a userform which has a label as a question and 3 radios buttons as an answer. The form is this

    http://tinypic.com/r/6gaj2q/9

    http://i65.tinypic.com/6gaj2q.jpg

    When use click on...
  15. Thread: left() in vba

    by lezawang
    Replies
    4
    Views
    104

    left() in vba

    Hi
    I wanted to do the code below without using for-loop, but it did not work. Is it possible to do it without For loop?
    Thank you so much.


    Sub myleft()
    'For x = 1 To 10
    'Cells(x, 2)...
  16. Replies
    5
    Views
    141

    Re: UserForm name does not change

    Got it. Thank you all.
  17. Replies
    5
    Views
    141

    Re: UserForm name does not change

    Thanks for your reply. No I mean the code should be like this


    Private Sub MyUserForm_initialize()
    End Sub
  18. Replies
    5
    Views
    141

    UserForm name does not change

    Hi
    I inserted UserForm and some other Form Controls such as textboxes/labels etc. I changed the name of each control for example TextBox1 to Mybox, Label1 to Mylabel etc. I also changed the name of...
  19. Changing background color of a userform after each click

    Hi
    I want to change the background color of a userform when a user click anywhere inside the form. Change the color different from previous one whenever user click on the form. I tried the following...
  20. Replies
    6
    Views
    175

    Re: fill blank cells with 0

    Thank you very much all.
  21. Replies
    6
    Views
    175

    fill blank cells with 0

    Hi
    I want to fill blank cells with 0. The code below gave me error message
    complaining that rows.count overflow. I changed it to 1000 and it worked
    My question, why I got that error message, and...
  22. Replies
    5
    Views
    122

    Re: for each sheet in worksheets

    Thank you all. Yes if I start with i=1 then I am ok. Not sure why? I did the same thing for Cells and it works even when I=0



    Sub myselection3()
    Dim xcell As Range
    Dim i As Integer
    i = 0...
  23. Replies
    5
    Views
    122

    for each sheet in worksheets

    Hi the code below does not work. Complaining about

    xsheet.Tab.ColorIndex = i

    I did similar idea with cells and everything was fine. Please see the second code. Thank you so much.


    Sub...
  24. Replies
    7
    Views
    180

    Re: application object - vba functions

    Ok got it. Thank you so much once again.
  25. Replies
    7
    Views
    180

    Re: application object - vba functions

    Thank you once again for the help. I see that I can call Sum for example using

    Application.sum

    Or

    Worksheetfunction.sum

    but if that is the case, when I say Application.sum, from Object...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4