I've got a pretty long-running macro inside a UserForm, and I wanted
to open a second form just to show that things are still working and
not crashed. It's pretty simple - four labels and I cycle around
turning one at a time a different color.
I call it from the main form with
Private Sub Command
I have a form with 7 combo boxes on it and I'd like to take the values
from the selections and store the value into an array. Some
background: The first two combo boxes must be selected otherwise the
form should not do anything. As long as the first two equal a value,
the rest of them *could* be
Sorry I didn't get back to you earlier.. I had to scrap this approach
as it wasn't going to work in the long run. Requirements changed,
actually, it's a bit of scope creep, but c'est la vie.
On Oct 11, 10:47 am, Paul Schreiner wrote:
> How are you calling thefunction?
>
> I copied yourfunctionto
hi experts,
its a rolling up method
for example
if raw cdr having No 93854512115
then formula should find name for this no if didnt then
it roll up one no and then find again (like 9385451211)
till finding name it will rolling up
hope now u understand
Girish
On Tue, Oct 19, 2010 at 1:24 PM,
Please check the attachment,
On Tue, Oct 19, 2010 at 10:32 AM, girish kumar
wrote:
> Hi Krishna,
>
> see file attached, in that second sheet u see in b column i used Left
> function and in c column Vlookup
>
> left function i used =left(A2.13)
>
> and vlookup answer is #N/A
>
> Becau
Dear all
Can someone help me in this or provide a better spreadsheet?
On Mon, Oct 18, 2010 at 8:47 AM, Yahya wrote:
>
> Dear all
>
> I use the attached excel sheet to calculate the profit/loss in the trading
> of individual stocks. The formula works fine in normal cases. But whenever
> there
Hello, Dear
Please check this. Perhaps you need this.
Thanks
Chandra Gupta Maurya
On Mon, Oct 18, 2010 at 7:52 PM, girish kumar
wrote:
> Dear Experts,
>
> need one urgent help from you guys i have attached one file having 2 sheets
> named "system data" & "Raw CDR"
>
> i need a formula for getti
A break through
Maintain your holidays in a worksheet.
(either maintain them in ascending order
or order them through code
depending on the frequency of changes in holidays)
In the function just count the holidays falling between start_date and
end_date
simply deduct them from the getworkdays.
R
Dear Girish
Please find herewith enclosed file.
regards
sumit
On Tue, Oct 19, 2010 at 10:32 AM, girish kumar
wrote:
> Hi Krishna,
>
> see file attached, in that second sheet u see in b column i used Left
> function and in c column Vlookup
>
> left function i used =left(A2.13)
>
> and vlookup
