Use the macro window to insert the user form fields.
On 2/22/12, zoher <[email protected]> wrote: > madam where i can get the option of user form field? in excel 2007? > ----- Original Message ----- > From: "Suman Dogra" <[email protected]> > To: <[email protected]> > Sent: Tuesday, February 21, 2012 2:51 PM > Subject: Re: [AI] Conditional formatting > > >> If you want to use a drop edit field, use the data validation. >> If you want to use a combo box, use the user form fields. >> >> >> On 2/15/12, Mukesh <[email protected]> wrote: >>> I have 5 options which the students should select while filling up the >>> form. >>> Actually it should be a combo box rather than drop down list. Please >>> guide >>> me how to create a combo box in excel 2007. Thank you. >>> >>> Regards >>> >>> Mukesh Baviskar >>> >>> -------------------------------------------------- >>> From: "Suman Dogra" <[email protected]> >>> Sent: Wednesday, February 15, 2012 11:26 AM >>> To: <[email protected]> >>> Subject: Re: [AI] Conditional formatting >>> >>>> Please specify, you want to insert a combo box or a drop edit field. >>>> >>>> >>>> >>>> >>>> On 2/14/12, Mukesh <[email protected]> wrote: >>>>> Thank you. It works fine. Now I have one more query as follows: >>>>> >>>>> 1. I want to create a combo box/drop down list in cell e6. >>>>> 2. It should contain the words 'yes' 'no' >>>>> >>>>> How to do this? Thank you. >>>>> >>>>> Mukesh Baviskar >>>>> >>>>> -------------------------------------------------- >>>>> From: "zoher" <[email protected]> >>>>> Sent: Monday, February 13, 2012 11:44 AM >>>>> To: <[email protected]> >>>>> Subject: Re: [AI] Conditional formatting >>>>> >>>>>> yes you can do it. but the jaws will not report the right color. do >>>>>> the >>>>>> following things: >>>>>> 1 select the cell E5 then go to home tab by pressing alt+h. >>>>>> 2by pressing tab key go to stile tool bar and select conditional >>>>>> formatting.and hit enter. >>>>>> 3select heighlight cell rools submenu and hit enter. >>>>>> 4 select >then and hit enter and type your value 80 in your case. >>>>>> 5 now press tab key ones and select the color of your choice to be >>>>>> displayed if figure is >then 80. >>>>>> 6 now press tab ones and press enter on ok button. >>>>>> now you will notice that when the value of cell is >80 then the color >>>>>> of >>>>>> cell will be of your choice . >>>>>> now focose on the same cell follow the same steps above with little >>>>>> chainges. >>>>>> in step 4 we had selected >then but here select <then and press enter, >>>>>> and >>>>>> >>>>>> type the value as 81 in your case and select the color of your choice >>>>>> and >>>>>> hit on ok. >>>>>> you are done >>>>>> e ----- Original Message ----- >>>>>> From: "Mukesh" <[email protected]> >>>>>> To: "Access India" <[email protected]> >>>>>> Sent: Sunday, February 12, 2012 10:03 AM >>>>>> Subject: [AI] Conditional formatting >>>>>> >>>>>> >>>>>>> Hello Friends, >>>>>>> I am using M. S. Office 2007. I want to create a conditional >>>>>>> formatting >>>>>>> rule for my table in Excel. The conditional formatting rule is as >>>>>>> follows: >>>>>>> 1. I want to apply rule in cell e5. >>>>>>> 2. If the cell value of e5 is <80, a colour of cell value should be >>>>>>> red. >>>>>>> 3. If the cell value of e5 is >=80, a colour of cell value should be >>>>>>> green. >>>>>>> >>>>>>> I want to apply these two conditions in a same cell e5. It is very >>>>>>> urgent >>>>>>> >>>>>>> for me because my work is stopped due to this problem. Waiting for >>>>>>> your >>>>>>> guidance at the earliest. Thank you. >>>>>>> >>>>>>> Regards >>>>>>> >>>>>>> Mukesh Baviskar >>>>>>> Mobile: 9403161157 >>>>>>> >>>>>>> Search for old postings at: >>>>>>> http://www.mail-archive.com/[email protected]/ >>>>>>> >>>>>>> To unsubscribe send a message to >>>>>>> [email protected] >>>>>>> with the subject unsubscribe. >>>>>>> >>>>>>> To change your subscription to digest mode or make any other changes, >>>>>>> please visit the list home page at >>>>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> Search for old postings at: >>>>>> http://www.mail-archive.com/[email protected]/ >>>>>> >>>>>> To unsubscribe send a message to >>>>>> [email protected] >>>>>> with the subject unsubscribe. >>>>>> >>>>>> To change your subscription to digest mode or make any other changes, >>>>>> please visit the list home page at >>>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>>> >>>>> >>>>> >>>>> Search for old postings at: >>>>> http://www.mail-archive.com/[email protected]/ >>>>> >>>>> To unsubscribe send a message to >>>>> [email protected] >>>>> with the subject unsubscribe. >>>>> >>>>> To change your subscription to digest mode or make any other changes, >>>>> please >>>>> visit the list home page at >>>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>>> >>>>> >>>> >>>> >>>> Search for old postings at: >>>> http://www.mail-archive.com/[email protected]/ >>>> >>>> To unsubscribe send a message to >>>> [email protected] >>>> with the subject unsubscribe. >>>> >>>> To change your subscription to digest mode or make any other changes, >>>> please visit the list home page at >>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>>> >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> with the subject unsubscribe. >>> >>> To change your subscription to digest mode or make any other changes, >>> please >>> visit the list home page at >>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >>> >>> >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> > > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
