date:20131031

$$Excel-Macros$$ RE: [XL-VBA Clinic] Happy Diwali.

2013-10-31 Thread Ravinder

HAPPY DIWALI TO ALL FRIENDS..

 

From: excelvbacli...@googlegroups.com
[mailto:excelvbacli...@googlegroups.com] On Behalf Of Dharmendra Upadhyay
Sent: Friday, November 01, 2013 11:06 AM
To: excelvbacli...@googlegroups.com
Subject: Re: [XL-VBA Clinic] Happy Diwali.

 

Same to u & your family

On Nov 1, 2013 10:23 AM, "Kuldeep Upadhyay"  wrote:

Dear all happy Dhanteras & Diwali.

-- 

--
To post to this group, send email: 
excelvbacli...@googlegroups.com
To unsubscribe from this group, send email
excelvbaclinic+unsubscr...@googlegroups.com
 
 
For more options, visit this group at
http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
--- 
You received this message because you are subscribed to the Google Groups
"Excelvbaclinic" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excelvbaclinic+unsubscr...@googlegroups.com
 .
For more options, visit https://groups.google.com/groups/opt_out.

-- 

--
To post to this group, send email: 
excelvbacli...@googlegroups.com
To unsubscribe from this group, send email
excelvbaclinic+unsubscr...@googlegroups.com
 
For more options, visit this group at
http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
--- 
You received this message because you are subscribed to the Google Groups
"Excelvbaclinic" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excelvbaclinic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

2013-10-31 Thread Hilary Lomotey

thanks Sam, i guess my explanation was not understood. i like using
indirect functions like the example i sited, however in large sheets, it
seems this formula slows down the work book, so i was looking for a VBA
solution to look through any sheets when you select it just like the
indirect function is doing.Hope i can get assistance with that. thanks


On Thu, Oct 31, 2013 at 6:24 PM, Sam Mathai Chacko wrote:

>  [image: Boxbe]  This message is eligible
> for Automatic Cleanup! (samde...@gmail.com) Add cleanup 
> rule|
>  More
> info
>
> PFA
>
>
>
> On Thu, Oct 31, 2013 at 11:50 PM, Hilary Lomotey wrote:
>
>> thanks Sam, can you send it in excel format, i typed indirectvba=then i
>> refered to the datavalidation, but am getting an error. kind;y send me the
>> file. thanks
>>
>>
>> On Thu, Oct 31, 2013 at 6:15 PM, Sam Mathai Chacko wrote:
>>
>>> Function INDIRECTVBA(strSource As String)
>>>
>>> INDIRECTVBA = Evaluate("=" & strSource)
>>>
>>> End Function
>>>
>>> Regards,
>>> Sam Mathai Chacko
>>>
>>>
>>> On Thu, Oct 31, 2013 at 11:38 PM, Hilary Lomotey wrote:
>>>
 Hello Experts,

 i need an assistance with an alternative way of getting the indirect
 function of excel in VBA. I have attached a sample for your perusal.
 Basically i want to be able to do what i have done in the attached with
 VBA. Pls assist. thanks

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.

>>>
>>>
>>>
>>> --
>>> Sam Mathai Chacko
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

2013-10-31 Thread Sam Mathai Chacko

PFA



On Thu, Oct 31, 2013 at 11:50 PM, Hilary Lomotey  wrote:

> thanks Sam, can you send it in excel format, i typed indirectvba=then i
> refered to the datavalidation, but am getting an error. kind;y send me the
> file. thanks
>
>
> On Thu, Oct 31, 2013 at 6:15 PM, Sam Mathai Chacko wrote:
>
>> Function INDIRECTVBA(strSource As String)
>>
>> INDIRECTVBA = Evaluate("=" & strSource)
>>
>> End Function
>>
>> Regards,
>> Sam Mathai Chacko
>>
>>
>> On Thu, Oct 31, 2013 at 11:38 PM, Hilary Lomotey wrote:
>>
>>> Hello Experts,
>>>
>>> i need an assistance with an alternative way of getting the indirect
>>> function of excel in VBA. I have attached a sample for your perusal.
>>> Basically i want to be able to do what i have done in the attached with
>>> VBA. Pls assist. thanks
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>>
>>
>> --
>> Sam Mathai Chacko
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Sam Mathai Chacko

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Us

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

2013-10-31 Thread Hilary Lomotey

thanks Sam, can you send it in excel format, i typed indirectvba=then i
refered to the datavalidation, but am getting an error. kind;y send me the
file. thanks


On Thu, Oct 31, 2013 at 6:15 PM, Sam Mathai Chacko wrote:

> Function INDIRECTVBA(strSource As String)
>
> INDIRECTVBA = Evaluate("=" & strSource)
>
> End Function
>
> Regards,
> Sam Mathai Chacko
>
>
> On Thu, Oct 31, 2013 at 11:38 PM, Hilary Lomotey wrote:
>
>> Hello Experts,
>>
>> i need an assistance with an alternative way of getting the indirect
>> function of excel in VBA. I have attached a sample for your perusal.
>> Basically i want to be able to do what i have done in the attached with
>> VBA. Pls assist. thanks
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

2013-10-31 Thread Sam Mathai Chacko

Function INDIRECTVBA(strSource As String)

INDIRECTVBA = Evaluate("=" & strSource)

End Function

Regards,
Sam Mathai Chacko


On Thu, Oct 31, 2013 at 11:38 PM, Hilary Lomotey  wrote:

> Hello Experts,
>
> i need an assistance with an alternative way of getting the indirect
> function of excel in VBA. I have attached a sample for your perusal.
> Basically i want to be able to do what i have done in the attached with
> VBA. Pls assist. thanks
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Sam Mathai Chacko

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Alternative to indirect Function in VBA

2013-10-31 Thread Hilary Lomotey

Hello Experts,

i need an assistance with an alternative way of getting the indirect
function of excel in VBA. I have attached a sample for your perusal.
Basically i want to be able to do what i have done in the attached with
VBA. Pls assist. thanks

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.


Indirect Fuction In VBA.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Userform If-Else Error in German Excel sheet

2013-10-31 Thread mayur patil

Hello all,


In *German excel worksheet* I created an userform which has following code

'''
Private Sub CommandButton1_Click()

TextBox6.Value = (TextBox2.Value * TextBox3.Value * TextBox4.Value) / 
(TextBox5.Value)

If TextBox1.Value <= TextBox6.Value Then
MsgBox "Ned <= Nrd" & vbNewLine & "Erfüllt"
Else
MsgBox "Ned > Nrd" & vbNewLine & "Nicht erfüllt"
End If
End Sub
'''
My Problem explained by an example:

Initially I enter values for TextBox2.Value , TextBox3.Value , 
TextBox4.Value  and TextBox5.Value  

The calculated value of TextBox6.Value (Nrd) I get is 150

If I give TextBox1.Value = 10 or 100 then message ''Ned<=Nrd Erfüllt'' is 
seen, which is fine but if TextBox1.Value = 1000 still it shows same 
message instead of ''Ned > Nrd Nicht erfüllt''. 

What could be the reason for it? If anyone could help , I would be grateful.

Thanks.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ task notification in excel

2013-10-31 Thread Seba

Hi guys,

I need help with designing a task notification system in Excel.

*Some background:*

I do project management in Excel and I've automated the entire process with 
VBA to great extent. The only remaining problem is the task notification 
system. When I assign a project task to a specific user email notification 
is required. Currently I'm using an external system which means additional 
manual work. (and Outlook doesn't work because it doesn't support 
chain-like ordered mails)


*Desired result:*

In my project file I'd like to trigger the task assignment to one (or all) 
project memeber(s) which would in turn copy task details to their specific 
spreadsheets for workload and task monitoring. In their spreadsheets there 
needs to be a status column (in my project file as well, of course) and 
when they change the status of the task it also changes in other respective 
places and if possible some sort of notification appears (in form of msg 
box or something).


*Challenges:*

1. The two files I've mentioned are behind restricted access  and can only 
be viewed by a user with proper access rights. Users can't access the 
project file.I guess to bypass this I need to setup a third file to be used 
for communication.

2. In most cases there are several users doing tasks in a specific 
workflow. So the notification system hast to handle multiple assignments in 
desired order.
*

My questions to you:*
1. Is this feasible in Excel or has anyone tried to do something like this?
2. Are my assumtions correct or should I try something different? In Excel 
that is. I know some might say I need to transfer this to proper 
application as it is too complex, but I ran out of time for 2014:(

Thank you for your help. Any ideas are most welcome.

Kind regards,
seba

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

2013-10-31 Thread TAWHID

Wow! Its working.

Thanks a lot!

On Wednesday, 30 October 2013 11:42:27 UTC+1, TAWHID wrote:
>
> Can anyone let me know whats wron in this code below? When I run it says 
> error in this line: Set lookFor = Me.TextBox1
>
> Private Sub TextBox1_Change()
>
> Dim lookFor As Variant
> Dim rng As Range
> Dim col As Integer
> Dim found As Variant
>
> Set lookFor = Me.TextBox1
> Set rng = Sheets("MSR_Input").Columns("A:C")
> col = 2
>
> On Error Resume Next
> found = Application.VLookup(lookFor, rng, col, 0)
> If IsError(found) Then
> MsgBox lookFor & " not found"
> Else: UserForm1.Label2.Caption = found ': MsgBox "The look-up value of " & 
> lookFor & " is " & found & " in column " & col
>
> End If
> On Error GoTo 0
>
> End Sub
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ RE: [XL-VBA Clinic] Happy Diwali.

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

Re: $$Excel-Macros$$ Alternative to indirect Function in VBA

$$Excel-Macros$$ Alternative to indirect Function in VBA

$$Excel-Macros$$ Userform If-Else Error in German Excel sheet

$$Excel-Macros$$ task notification in excel

$$Excel-Macros$$ Re: VlookUp VBA : Can't link up with a Text Box

9 matches

Site Navigation

Mail list logo

Footer information