# Search:

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

Page 1 of 6 1

1. ## Thread: arrays and totalling an element

by AlphaFrog
Replies
3
Views
106

### Re: arrays and totalling an element

Dim datalistarray() As String

You declared datalistarray as a String-type.

total = total + datalistarray(a, 3)

When you use String + String, it concatenates strings. Not sums them.

Try...
2. ## Thread: Help with Copy Method (Macro)

by AlphaFrog
Replies
7
Views
119

### Re: Help with Copy Method (Macro)

Did you try my code... unchanged?

by AlphaFrog
Replies
17
Views
463

### Re: Question On Conditional Ranking

Yes it should work with decimals.
4. ## Thread: Help with Copy Method (Macro)

by AlphaFrog
Replies
7
Views
119

### Re: Help with Copy Method (Macro)

The code I suggested works.

You nested your IF statements, and you didn't use proper indentation so it's not obvious you nested the IF statements.

This is your unchanged code with proper...
5. ## Thread: Help with Copy Method (Macro)

by AlphaFrog
Replies
7
Views
119

### Re: Help with Copy Method (Macro)

Sub Update_Sheets()

If MsgBox("Do you wish to Update 'Members'", vbYesNo + vbQuestion, "") = vbYes Then
...
6. ## Thread: find case in a certain cell

by AlphaFrog
Replies
6
Views
131

### Re: find case in a certain cell

Case LCase(Sheet4.Range("A2").Value): Clr = 45
7. ## Thread: find case in a certain cell

by AlphaFrog
Replies
6
Views
131

### Re: find case in a certain cell

Case LCase(Range("A2").Value): Clr = 45
8. ## Thread: Working out an average in days, months years

by AlphaFrog
Replies
2
Views
28

### Re: Working out an average in days, months years

Your Length Of Absence (LOA) formula returns a text result. If you want to use those results in further calculations and formulas, you'll need numeric results. Perhaps it would be easier to just...
9. ## Thread: find case in a certain cell

by AlphaFrog
Replies
6
Views
131

### Re: find case in a certain cell

I don't understand what that means.
10. ## Thread: Open Directory for user to choose a file

by AlphaFrog
Replies
12
Views
290

### Re: Open Directory for user to choose a file

Dim wkb2 As Workbook, strFileName As String, FileFilter As String

ChDir ThisWorkbook.Path

FileFilter = "Excel 2003 (*.xls),*.xls," & _
"Excel 2007 >...
11. ## Thread: Why the row selected is displayed in negative value : Range ().value = Target.row

by AlphaFrog
Replies
2
Views
83

### Re: Why the row selected is displayed in negative value : Range ().value = Target.row

The code loops through each cell selected. With the first cell in the loop, it puts something like (1). Excel evaluates that entry to just its' numeric negative (like a currency value).

Just...
12. ## Thread: Open Directory for user to choose a file

by AlphaFrog
Replies
12
Views
290

### Re: Open Directory for user to choose a file

Set wkb2 = Workbooks.Open(strFileName, False, False)

When the workbook is opened, the variable wkb2 is set to it. Just reference wkb2. It is the opened workbook regardless of the file name.

...
13. ## Thread: Open Directory for user to choose a file

by AlphaFrog
Replies
12
Views
290

### Re: Open Directory for user to choose a file

Dim wkb2 As Workbook
Dim strFileName As String
Dim FileFilter As String

ChDir ThisWorkbook.Path

FileFilter = "Excel 2003 (*.xls),*.xls," & _
"Excel...
14. ## Thread: Open Directory for user to choose a file

by AlphaFrog
Replies
12
Views
290

### Re: Open Directory for user to choose a file

ChDir ThisWorkbook.Path

FileFilter = "Excel 2003 (*.xls),*.xls," & _
"Excel 2007 > (*.xlsx),*.xlsx," & _
"All Excel Files (*.xl*),*.xl*," & _
"All Files (*.*),*.*"

GetFileName =...
15. ## Thread: Passing Text Box value to another Text Box

by AlphaFrog
Replies
5
Views
127

### Re: Passing Text Box value to another Text Box

Use something like this...

txtAmount.Value = Format(MySum, "#,##0")
16. ## Thread: Open Directory for user to choose a file

by AlphaFrog
Replies
12
Views
290

### Re: Open Directory for user to choose a file

Is "Element List (whatever the user had named the file).xlxs" in the same folder as the workbook that has the macro code?

If yes...

ChDir ThisWorkbook.Path

FileFilter = "Excel 2003...
17. ## Thread: Passing Text Box value to another Text Box

by AlphaFrog
Replies
5
Views
127

### Re: Passing Text Box value to another Text Box

I don't know what that format is. It doesn't work for my version of Excel.

Try something like this. I can't test it. You may have to adjust it.

Private Sub txtDiscount_Change()
...
18. ## Thread: Passing Text Box value to another Text Box

by AlphaFrog
Replies
5
Views
127

### Re: Passing Text Box value to another Text Box

Private Sub txtDiscount_Change()
Me.txtTotal = Me.txtAmount - Me.txtDiscount
Me.txtPaid.Text = Me.txtTotal
Me.txtRest = Me.txtTotal - Me.txtPaid
End Sub

Private Sub...
19. ## Thread: Crazy Date Formatting????

by AlphaFrog
Replies
4
Views
179

### Re: Crazy Date Formatting????

Select the 4 columns
Replace (Ctrl+H) the / with a / to convert the dates en masse
Format them to suit
20. ## Thread: User Form data entry as date and number!!!

by AlphaFrog
Replies
4
Views
74

### Re: User Form data entry as date and number!!!

Try this...

ws.Cells(nr, 1) = CDate(Me.TextBox1) 'Date

ws.Cells(nr, 4) = CCur(Me.TextBox4) 'Amount
21. ## Thread: How to read approx 200 excel file in a single excel sheet one by one.

by AlphaFrog
Replies
1
Views
49

### Re: How to read approx 200 excel file in a single excel sheet one by one.

RDBMerge is a user friendly way to Merge Data from Multiple Excel Workbooks,
csv and xml files into a Summary Workbook.

22. ## Thread: Crazy Date Formatting????

by AlphaFrog
Replies
4
Views
179

### Re: Crazy Date Formatting????

When you imported the data, the dates were seen by Excel as text and not serial dates. A simple way to coerce the text-dates into serial dates is to select the date column and simply do a Replace...
23. ## Thread: How do I get a label in a scatter plot instead of "Series 1 Point"?

by AlphaFrog
Replies
5
Views
129

### Re: How do I get a label in a scatter plot instead of "Series 1 Point"?

Hide columns H:I
Make an Scatter chart with data range G6:K98 and data series in Rows
24. ## Thread: How do I get a label in a scatter plot instead of "Series 1 Point"?

by AlphaFrog
Replies
5
Views
129

### Re: How do I get a label in a scatter plot instead of "Series 1 Point"?

It works for me. How is your chart data layed out.

I put the series names in A2:A5
The X-axis values in B1:M1
And the Y-Axis values in B2:M5
A1 is blank

Used A1:M6 as the source data (series...
25. ## Thread: When Excel macro can't capture steps I carried out

by AlphaFrog
Replies
2
Views
62

### Re: When Excel macro can't capture steps I carried out

I usually just do a web search for something like Excel VBA Insert Picture in Comment

This was the 2nd link in the search results. It's a step-by-step guide.
VBA Code To Insert An Image Into A...
Results 1 to 25 of 150
Page 1 of 6 1