On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Tuesday, December 26, 2017

How to Say Thanks and You are Welcome

There are many ways of saying Thanks and You're Welcome. Today we are mentioning here some of the best ways of saying Thanks and You're Welcome:

         Different ways of saying Thank You:

           1. Thank you so much.
           2. You are a life saver.

Monday, December 25, 2017

Oxygen Plants Identified by NASA

Today we showing you SEVEN OXYGEN PLANTS, which are Identified by NASA to CLEAN AIR AT HOME - Everyone should follow & Spread this info. The purpose of sharing this info is:

Across the world many cities like LONDON, MUMBAI, NEW DELHI, BEIJING etc... are extremely polluted & causing many hazardous diseases. Everyone is getting effected especially Infants & Old Age People.

Monday, December 18, 2017

Create a Custom Function in Excel - UDF

You can create your very own functions that does whatever you want it to; are called User Defined Functions, or UDF, and they are amazing.

To make these functions; we just need a little bit of VBA since they are basically macros.

Steps to Create a UDF in Excel

1. Hit Alt + F11 to go to the VBA Editor window.

 2. Go to Insert > Module

You should now see a window that looks like this:

3. In that window type Function and the name of your function and then an open and closing parenthesis and then hit Enter. I named my function CountCharacters

You can give your function basically any name that is not already used for functions.

Once you do this, the window will automatically add End Function to the window and it should look something like this: 

 4. Put some code within the function to make it do something.

     Here, I will simply set a variable equal to some text that I would like to output.

 outputText = "This is output."  

5. Now, we need to put the output of our function into a variable that has the SAME name as our function.

To do this, I add this line of code to the bottom of the function's code:
 CountCharacters = outputText  

6. Hit Alt + F11 to go back to Excel and input the new function into a cell.

Notice that when I start typing the name of the function it appears in the function list drop-down for Excel.

When you finish entering the function hit Enter like you would with a regular function.

7. That's it! Here is the final result.

In this example I created the simplest form of a UDF or User Defined Function.

Every UDF that you create will follow the basic structure outlined in this example, which is:

  1. Functions must start with Function and then the name you want to give that function and an open and closing parenthesis. Arguments can go into the parenthesis, as discussed below in another example.
  2. Functions must end with the text End Function, which the Excel VBA window will usually input for you.
  3. To generate the output for the function and send it back to Excel, you must assign the output of the function to a variable that has the exact same name as your function.

Adding Arguments to the Function

Let's now add an argument to the function in order to make it more useful.

Arguments are the parts of a function where you can input data, or select a cell that has data, that you want your function to use. Arguments are the way you get data into your function.

It's actually very simple; we just input text in-between the parenthesis after the name of the function, and that text will be the argument.

Let's start with the example we made above:

Now, add text in the parenthesis:

I put input_value as the argument. Note that you can't use spaces for the names, instead, separate words using underscores.

Now that we have input_value as an argument, we can use it within the function. This is how we get data from the user into the function.

To make this function more dynamic, since it currently only outputs the hardcoded text "This is output.", I will set the variable outputText equal to the new argument input_value.

Go back to Excel (hit Alt + F11) and let's try this function on another cell.

Here is the result:


This simple function now outputs whatever text is given to it, in this case, the text from cell A1.

Multiple Arguments

You can have multiple arguments, just separate each one with a comma like this:

 Function MyFunctionName(Argument_1, Argument_2, Etc.)  

Using VBA within the Function

We are creating this function using VBA (Visual Basic for Applications), which is the same thing we use for regular macros. As such, we can do many interesting and powerful things. Now, functions can't do everything that a regular macro can do, because the goal of a function is to return a result back to the cell, but you can still do a lot.

Let's finish the function we started to create and make it count all of the characters that are in a cell.
To do this, we add the len VBA function, which is used to count the length of the value that you put inside of it.

I want to count the input to this function, which is provided through the input_value variable and so I need to put that inside the len function.


 outputText = input_value  

Will become this:

 outputText = len(input_value)  

Since the rest of the function is already setup to output the value stored in the outputText variable, I don't need to change anything else.

Here is the final Function code:

Go back to Excel and try it now.

Output is:

We now have a function that counts how many characters are in a cell and gives us the result.

The Final Result: Custom Excel Function

This was a very simple example using VBA to create a function but you can include many lines of code depending on the complexity of what you are trying to do. In this example, I tried to keep things simple to help give you an idea of how everything works so you can build upon it.
Here is the final version of the code that was created:

 Function CountCharacters(input_value)  
   outputText = Len(input_value)  
   CountCharacters = outputText  
 End Function  


Custom Excel functions, or UDFs, are simply awesome. They are one of my favorite aspects of Excel because it allows you to easily create a function that does almost whatever you could want it to do. When you have repetitive tasks that take many steps or require a complex formula that is hard to remember, you can create a custom function to do the work for you.

The example that I created above is not a useful custom function on its own since there is already a LEN() function in Excel, but it should help you to understand how custom functions are made and used.

UDFs are only available in the workbook in which you have them or when that workbook is open and you are referencing them using the correct cross-workbook method, with is rather annoying. In another tutorial I will show you how to make them available everywhere.

Important Health Tips In Hindi

                                प्रश्न            उत्तर

1. सुबह उठ कर कैसा पानी पीना चाहिए            हल्का गर्म

2.  पानी पीने का क्या तरीका होता है                      सिप सिप करके व नीचे बैठ कर

3. खाना कितनी बार चबाना चाहिए                      32 बार

4.  पेट भर कर खाना कब खाना चाहिए                      सुबह

5.  सुबह का नाश्ता कब तक खा लेना चाहिए                      सूरज निकलने के ढाई घण्टे तक

6.  सुबह खाने के साथ क्या पीना चाहिए                      जूस

7.  दोपहर को खाने के साथ क्या पीना चाहिए                      लस्सी / छाछ

8.  रात को खाने के साथ क्या पीना चाहिए                      दूध

9.  खट्टे फल किस समय नही खाने चाहिए                      रात को

10. आईसक्रीम कब खानी चाहिए                      कभी नही

11. फ्रिज़ से निकाली हुई चीज कितनी देर बाद खानी चाहिए               1 घण्टे बाद

12. क्या कोल्ड ड्रिंक पीना चाहिए                      नहीं

13.  बना हुआ खाना कितनी देर बाद तक खा लेना चाहिए                      40 मिनट

14.  रात को कितना खाना खाना चाहिए                      न के बराबर

15.  रात का खाना किस समय कर लेना चाहिए                      सूरज छिपने से पहले

16. पानी खाना खाने से कितने समय पहले पी सकते हैं                      48 मिनट

17.  क्या रात को लस्सी पी सकते हैं                      नही

18.  सुबह खाने के बाद क्या करना चाहिए                      काम

19. दोपहर को खाना खाने के बाद क्या करना चाहिए                      आराम

20. रात को खाना खाने के बाद क्या करना चाहिए                      500 कदम चलना चाहिए

21. खाना खाने के बाद हमेशा क्या करना चाहिए                      वज्रासन

22. खाना खाने के बाद वज्रासन कितनी देर करना चाहिए            5-10 मिनट

23.  सुबह उठ कर आखों मे क्या डालना चाहिए                      मुंह की लार

24.  रात को किस समय तक सो जाना चाहिए                      9-10 बजे तक

25. तीन जहर के नाम बताओ                      चीनी , मैदा , सफेद नमक

26. दोपहर को सब्जी मे क्या डाल कर खाना चाहिए                      अजवायन

27.  क्या रात को सलाद खानी चाहिए                      नहीं

28. खाना हमेशा कैसे खाना चाहिए                      नीचे बैठकर व खूब चबाकर

29. चाय कब पीनी चाहिए                      कभी नहीं

30. दूध मे क्या डाल कर पीना चाहिए                      हल्दी

31.  दूध में हल्दी डालकर क्यों पीनी चाहिए                      कैंसर ना हो इसलिए

32. कौन सी चिकित्सा पद्धति ठीक है                      आयुर्वेद

33. सोने के बर्तन का पानी कब पीना चाहिए                      अक्टूबर से मार्च (सर्दियों मे)

34. ताम्बे के बर्तन का पानी कब पीना चाहिए                      जून से सितम्बर(वर्षा ऋतु)

35. मिट्टी के घड़े का पानी कब पीना चाहिए                       मार्च से जून (गर्मियों में)

36. सुबह का पानी कितना पीना चाहिए                      कम से कम 2-3 गिलास

37. सुबह कब उठना चाहिए                      सूरज निकलने से डेढ़ घंटा पहले।

Friday, December 15, 2017

Different ways of saying HELLO

If you want to say "Hello" to any anyone, then you can say by these different ways i.e.: 

           1. Hey there!     

           2. How are things with you?    

           3. What's new?     

           4. It's good to see you!   

           5. Look who it is!    

           6. What's up?     

           7. Long time!    

           8. How is it going? 

           9. How's life?        

           10. How do you do?


Monday, December 11, 2017

How to use Do-Play-Go

Do is used for a recreational activity or a non-team sport that does not use a ball.

1. Karate -
2. Judo -
3. Taekwondo -
कराटे जैसा एक  खेल
4. Kung-Fu -
कंग फ़ू
5. Athletics -
6. Aerobics -
हवाई करतब
7. Ballet -
नृत्य नाटिका
8. Yoga -
9. Archery -
धनुर्विद्या / तीरंदाज़ी
10. Tai-chi -
चीनी कसरत करने का तरीका

Play is used with ball sports or competitive games where we play against another person.

1. Basketball -
2. Baseball -
3. Tennis -
4. Golf -
5. Volleyball -
6. Football -
7. Rugby -
रग्बी फुटबाल
8. Chess -
9. Cricket -
10. Board games -
विशेष प्रकार के बोर्ड या पट्टे के खेल जैसे शतरंज
11. Hockey -
12. Snooker -
बिलियर्ड टेबल का खेल
13. Squash -
एक प्रकार का टैनिस जैसा खेल
14. Badminton -

Go is used with activities that end -ing. We go somewhere to do something.

1. Swimming -
2. Hiking -
पैदल लंबी यात्रा
3. Jogging -
4. Running -
5. Fishing -
मछ्ली पकड़ना
6. Bowling -
7. Fencing -
तलवार से लड़ाई करना
8. Wrestling -
9. Skiing -
10. Riding -
11. Sailing -


Different Ways of Saying HELLO

How to Say Thanks and You are Welcome

Different Ways of Saying GoodBye

Different Ways to Express Opinion

Wednesday, December 6, 2017

Different Ways to Express Opinion

1. In my opinion... - मेरी राय में...

2. If you ask me... -
अगर आप मुझसे पूछो तो...

3. The way I see it... -
जैसा मुझे लगता है...

4. It seems to me... -
मुझे लगता है...

5. As far as I can see... -
जहाँ तक मैं समझता हूँ...

6. As far as I am concerned... -
जहाँ तक मेरी बात है...

7. I feel... -
मुझे लगता है...

8. I honestly believe that... -
ईमानदारी से मैं मानता हूँ...

9. From my point of view... -
मेरे नज़रिए से...

10. Personally, I think... -
निजी तौर पर मुझे लगता है...

11. I'd like to point out that... -
मैं यह बताना चाहूँगा...

12. In my experience... -
मेरे अनुभव में...

13. I have observed that... -
मैंने यह देखा है...

14. I am not certain, but... -
मैं निश्चित नहीं हूँ, लेकिन...

15. I have mixed opinions on this -
इस मामले में मेरी बहुत सी राय हैं...

16. I have no opinion in the matter -
इस मामले में मेरी कोई राय नहीं है...


Different Ways of Saying HELLO

How to Use Do-Play-Go

Different Ways of Saying GoodBye

How to Say Thanks and You are Welcome

Popular Posts