Re: Calculate Compound Interest
check this file
may solve ur question
Re: Calculate Compound Interest
check this file
may solve ur question
Re: Related List In Listbox
If anybody interested I solved it in a way
Private Sub ComboBox1_Change()
Dim rng As Range
Dim cl As Range
Dim Dt(100) As String, X As Integer, Y As Integer
X = 0
With Me.ComboBox2
.Clear ' clear the listbox content
Set rng = Worksheets("Data").Range(Cells(6, 3), Cells(Rows.Count, 3).End(xlUp))
For Each cl In rng
If cl.Value = Me.ComboBox1.Value Then
For Y = 0 To X
If Dt(Y) = cl.Offset(0, -1).Value Then GoTo Nxt
Next Y
Dt(X) = cl.Offset(0, -1).Value
X = X + 1
Nxt:
End If
Next cl
End With
For Y = 0 To X - 1
Me.ComboBox2.AddItem Dt(Y)
Next Y
End Sub
Display More
Re: Related List In Listbox
Thanks royUK For your help
my main sheet having huge data
how can i make it unique dates
Thanks again
Please I need some help
I need the [COLOR="Blue"]listbox [/COLOR]to have the related dates to the salesman I am selecting in [COLOR="Blue"]Combox[/COLOR]
Not all dates
I'll be thankful for any help
You can check my Attachment
Re: Checking If Comment Exists To Copy It
Thanks a lot
worked fine
Re: Checking If Comment Exists To Copy It
Quotei dont know the where the problem
first 2 columns working fine
if u can check my file u will see
and thanks again
guys no one can help
Re: Checking If Comment Exists To Copy It
i dont know the where the problem
first to columns working fine
if u can check my file u will see
and thanks again
Re: Checking If Comment Exists To Copy It
Thanks Reafidy
I will Try it
Good Morning all
I trying to copy comment to cell
The problem I am facing when I ask for the comment and there is no comment
[COLOR="Blue"]Run-time error ‘91’:
Object Variable or With block variable not set[/COLOR]
Coming up
I am using this formula
I searched to much with no success
how can i check if [COLOR="blue"]Cells(Rw,Cl)[/COLOR] have lcomment to copy it
Re: Wildcard List Box Source
I know that I am asking too much
but how can i use this keycode to check in another language like french
waiting :confused:
Re: Wildcard List Box Source
Sorry I was out
I don’t know if this what do you suggest
QuoteSet ListRange = Range(Worksheets("sheet2").Cells(rTCell.Row + 1, rTCell.Column), _
Worksheets("sheet2").Cells(rTCell.Row + 1, rTCell.Column).End(xlDown))
It works fine with me
But in this case it must be in sheet2
Can we use named range instead
Thanks a lot it solved my problem
Re: Wildcard List Box Source
Thanks For your Reply Kenneth Hobson
i done what you told me
but list coming blank when i choose data in another sheet
Re: Wildcard List Box Source
I think like this better
i have these codes
QuotePrivate Sub UserForm_Initialize()
sChar = False
Me.Caption = [h1].Value
FillListBox [h1], Me.ListBox1 'Title cell for list and listbox control name
End Sub
and
QuoteDisplay MoreSub FillListBox(rTCell As Range, cListBox As MSForms.ListBox)
Dim i As Integer
Dim ListRange As Range, cel As Range
Application.ScreenUpdating = False
'Range for List must start just after Title cell, rTCell, and be contiguous
Set ListRange = Range(Cells(rTCell.Row + 1, rTCell.Column), _
Cells(rTCell.Row + 1, rTCell.Column).End(xlDown))
On Error Resume Next
With cListBox
.Clear ' remove existing entries from the listbox
For Each cel In ListRange
i = i + 1
.AddItem cel.Value
Next cel
.ListIndex = 0 'set to -1 to select no item, 0 for first item
End With
Application.ScreenUpdating = True
On Error GoTo 0
End Sub
This codes are using Column H for the Data
i need to use sheet3 in same workbook or named range in sheet3
waiting for your help
Hello All There
I Need Some Help i need to change the source data in the wildcard listbox
i need to be in same workbook but in another sheet
range can be named like employe
this file i took from thread and i was trying to change the source but no success
thanks
Re: Macro To Sort Rows By Date Order
Upside
the sell [COLOR="Blue"]E8[/COLOR] = John Ball 20/2/07 or 20/2/07
if you can send sample will be better
Re: Splitting Wrapped Cell Into Separated Cells
Thanks Andy Pope :confused:
the Problem was because i was trying my own VBA module by name split
: D thanks
Re: Splitting Wrapped Cell Into Separated Cells
No I Have XL2003 Ver 11.5
Re: Splitting Wrapped Cell Into Separated Cells
Thanks Andy Pope For Your time
When I run it gives compile error
And highlight [COLOR="Navy"]split[/COLOR] when I make debug
I need your help in VBA
I tried too much to split one cell
Containing more than one line
I need to put every line in deferent cell
My small example can describe better
Thanks in advance for your time