Search:

Type: Posts; User: MORT1703

Page 1 of 4 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    4
    Views
    369

    Re: Msgbox

    Using your code

    Sub Msg()
    Dim strMsg As String, strTitle As String, Ret
    '~~> Message goes here
    strMsg = "Whass Up?"
    '~~> Title goes here
    strTitle = "Info"
    ...
  2. Replies
    4
    Views
    369

    [RESOLVED] Msgbox

    Can someone tell me how to add a variable to the following piece of code

    MyChoice = MSGBOX("CHANGE INFO?" VBYESNO)
  3. Replies
    3
    Views
    392

    Re: Is It Possible

    The default excel column row/column headings

    A B C D E F G H I J K L ....
    1
    2
    3
    4
    5
    6
    7
  4. Replies
    3
    Views
    392

    Is It Possible

    is it possible to customise the row/column headers bar using code?
  5. Thread: grouping

    by MORT1703
    Replies
    2
    Views
    367

    Re: grouping

    I would record a macro if it would help, however I need to select my range via variables
  6. Thread: Font Size

    by MORT1703
    Replies
    3
    Views
    355

    Re: Font Size

    is it possible to do what your suggesting with code?
  7. Thread: Font Size

    by MORT1703
    Replies
    3
    Views
    355

    Font Size

    is it possible to select the entireworkbook and change the font size?

    without selecting each cell individually?
  8. Thread: grouping

    by MORT1703
    Replies
    2
    Views
    367

    grouping

    in excel I can group rows or columns together in order to show totals only when closed and when opened it shows all the information which makes up that total, how do I write a macro to do the same?
  9. Replies
    2
    Views
    349

    cell formating

    two questions

    1)
    how do I change the background colour of a specific cell?

    2)
    how I show a cell as being raised like a button?
  10. Replies
    1
    Views
    369

    on action coding

    I am using the following procedure within my excel project:


    Public Sub ADDBUTTONS(ASheet)
    Dim BILLCOUNT As Integer
    Dim INCOMECOUNT As Integer
    BILLCOUNT = Worksheets("BILLS").Range("D1")...
  11. Replies
    8
    Views
    533

    Re: days of the month

    Hi folks

    thanks for the reply, quick follow on.

    I have each day of the month displayed in a seperate columns, for formatting purposes I would like to group on a week basis, for example march...
  12. Replies
    8
    Views
    533

    days of the month

    I am using the following coding to determine the number of days in a month:

    cell B1 holds a date value ie 01/03/2009


    datemonth = Month(Sheets(ASheet).Range("B1").Value)
    If datemonth...
  13. Replies
    1
    Views
    365

    Is It Possible

    is it possible to use variables within the following context

    START = 0
    BILLCOUNT = 17

    START = START - BILLCOUNT

    ActiveCell.Value = "=SUM(R[START]C:R[-1]C)"
  14. Replies
    3
    Views
    338

    Re: moving data between worksheets

    All Bill contains rows of user entered information from a userform

    Once the user has entered the values, the code places all the entered information in to a row occupying various cells 1 value per...
  15. Replies
    3
    Views
    338

    moving data between worksheets

    I have a form which makes use of the WORKSHEETSELECTCHANGE function, the worksheetselectchange function runs this code.




    Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal...
  16. Replies
    2
    Views
    1,522

    Re: Workbook_SheetSelectionChange

    I know that the code only applies to the activesheet, what I don't know is how to change the code to do exactly that
  17. Replies
    2
    Views
    1,522

    Workbook_SheetSelectionChange

    When a user click on a column S which has an appropriate row of data it updates the status of the data from "OPEN" to "CLOSED" and adds a closed date, what I need is for the status to update on the...
  18. Replies
    14
    Views
    424

    Re: arrays

    Cheers mate works a treat
  19. Replies
    14
    Views
    424

    Re: arrays

    I see what you mean about my interpretation, my problem is using the 1d method isn't going to be practical, cos would require an array for every of data. let me run this past u.

    I have worked out...
  20. Replies
    14
    Views
    424

    Re: arrays

    is it possible to use this line

    dim arrayvalues(17,10)

    lRow = Range("B" & Rows.Count).End(xlUp).Row
    Active = Application.CountA(Range("B6:B" & lRow))

    redim arrayvalues(17, Active)
    ...
  21. Replies
    14
    Views
    424

    Re: arrays

    Hi

    I have a random number of rows, starting at cell B6 and going down the worksheet in column B. Each row has the same dimensions as the 1d array.

    as a result I need some code which is robust...
  22. Replies
    14
    Views
    424

    Re: arrays

    Hi KoolSid

    Thanks for the help with the array.

    with your code I have come up with the following:


    Dim ArrayValues(17)

    ' put values into the array
  23. Replies
    14
    Views
    424

    [RESOLVED] arrays

    I need to capture the following cell values into an array:

    B6,C6,D6,E6,F6,G6,H6,I6,J6,K6,L6,M6,N6,O6,P6,Q6,R6,S6

    and for the purpose of checking the results, I want to place the cell values...
  24. syntax for using a counter in a input box

    Hi I was to use an inputbox with this statement

    counter + " bills added"

    whats the correct syntax. I have tried :

    Application.InputBox(Counter + " bills added", "Counter")...
  25. Replies
    2
    Views
    279

    [RESOLVED] UK Dates

    I am using this code for assigning a date function to a cell on a worksheet, however any dates between 1st and 12th of any month is displaying in US format, any dates from the 13th onwards is...
  26. Thread: currency

    by MORT1703
    Replies
    1
    Views
    369

    currency

    How do I adapt the following code at userform level to format my values as currency


    With .Cells(lngNextRow, "G")
    .Resize(, 12).Value = 0
    ...
  27. Re: assigning macro to a cell from a userform

    if i'm reading your statement correctly, your code finds the first available blank cell in column "S", it then selects the cell. what code do I attach to it to allow the user to click on the cell and...
  28. assigning macro to a cell from a userform

    Hi

    how do I adjust this statement

    Sheets("ALL BILLS").Range("S" & Rows.Count).End(xlUp).Offset(1).Value = "OPEN"

    to give me the same result as the following code

    The worksheet in question...
  29. Replies
    11
    Views
    565

    Re: the date is changing, why?

    i dont think thats the problem to be fair, when I debug the code textday, textmonth, textyear are splitting correctly, when I put them into newdate, newdate is still got the correct valid date,...
  30. Replies
    11
    Views
    565

    Re: the date is changing, why?

    nothing I can see on the properties window, and yes we are talking about a userform in excel, sorry for not being clear. I was mistaken about where the problem was occuring, i have done a step by...
  31. Replies
    5
    Views
    409

    Re: userform query

    Hi folks thanks for the insight, u have aided me in coming up with this:


    Dim lngNextRow As Long
    If Frequency = "A" Then
    With Sheets("ALL BILLS")
    lngNextRow =...
  32. Replies
    11
    Views
    565

    the date is changing, why?

    hi

    can anyone tell me why this is giving me the wrong date

    I enter 13/10/08 and it keeps its date
    i enter a date between 1-12 october and the date days and months swap over giving me a...
  33. Replies
    5
    Views
    409

    Re: userform query

    Hi this does what it to do, however its rather long winded and bad coding, I imagine there is a easier way to do this, can anyone give me a hand to code this better


    Private Sub FillInBlanks()
    ...
  34. Replies
    5
    Views
    409

    userform query

    HI

    I am using a variable called DateCreated on userform

    I need to find a way of doing a for....next loop from column G to column R without knowing the row number

    for counter = 0 to 12
    ...
  35. Thread: dates

    by MORT1703
    Replies
    1
    Views
    332

    dates

    Hi

    I have three field on a userform called

    day = 20
    month = 12
    year = 08

    how can I merge these variables to hold 20/12/08
  36. Replies
    17
    Views
    9,966

    Re: control source property on userforms

    BILLRANGE uses this formula

    =OFFSET(ALL BILLS!$B$6,0,0,COUNTA(ALL BILLS!$B:$B)-1,1)

    and it was created on worksheet

    ALL BILLS
  37. Replies
    17
    Views
    9,966

    Re: control source property on userforms

    Thanks folks I was still using a TEXTBOX, I now changed it to a COMBOBOX

    I now get a different error message

    runtime error 1004

    method 'range' of object ' _worksheet' failed

    went through...
  38. Replies
    17
    Views
    9,966

    Re: control source property on userforms

    I have the following procedure which is giving me an error on this line of code, any ideas as to whats wrong

    .AddItem cPart.Value

    The error I get is




    Private Sub...
  39. Replies
    17
    Views
    9,966

    Re: control source property on userforms

    cheers mate, I've had a play since I posted this thread, and I realised I can sort out formatting out before the forms displayed by using this event

    Private Sub UserForm_Initialize()
    ...
  40. Replies
    17
    Views
    9,966

    Re: control source property on userforms

    hi

    I must be misunderstanding something cause I cant' find the a 3 (...) button

    I am clicking on my textbox, which puts the selected box around it
    I am then rightclicking on the mouse and...
Results 1 to 40 of 128
Page 1 of 4 1 2 3 4



Click Here to Expand Forum to Full Width