faraz bhai ek koshish ki hai ap ki problem solve karnay ki.
faraz bhai ek koshish ki hai ap ki problem solve karnay ki.
salam syar bhai mujhe excel main kuch problem thi or ek thread share ki thi per koi jawab nahi mila. ap ko link send kar raha hon plz help.
http://http://www.itdunya.com/t352475/#post3657392
thnx dear............bht bht shukriya apka.........mjhe lgta hai ke ye zaror kam karega....In Sha Allah........
is mai ek masla ha...mjhe aise kahe sheet banane hote hai..ek ke bd ek.....isliye jb mia neche use copy paste krta hon...to formula ke range change hojate hai......kya ya range constant nahe rh sakti....
thnx dear...............:-)
ye work krta hai.....:-)
Bhut Khoob dosto Excellent
wasalam,
Thanks for sharing. Actually m n jo aap ko kaha tha wo jese aap kah rahe the k list m lekhain aur auto complete ho tu us k leye kaha tha. Aur m n bhe aap ko dosri bar Combo BOx ka mashwara deya lekan light chale gai the jis ki wajha sa reply submit nahee ho saka. Aur phr m bhool gaya tha. Maqsad aap ka problem solve karna tha which i m glad k ho gaya ha. Yahan hm sab apne knowledge share karte hain, aur aik dosre sa sekhte hain.
Thanks & regards,
Aur ak totka bhe ha refer to http://www.itdunya.com/t285870/
Code:for VBA solution follow ( I assume you are familiar with excel commands & VBA therefore i shorten the procedure) Step1. Apni list ko formula---->define name----> ka zarye as "list1" define karain. ( I also assume your list on sheet 1) Step2 1. Press alt+F11 to open VBA editor Window 2. Insert ka menu m sa form select karain. Ye form ki window open karai ga. Form ko apni marzi ka mutabiq resize kar lain 3. left corner m form ki propoerties hote hain is m caption ki field m "Choose a Value" lekhai 4. Toolbox m se combobox ko select karain aur form m apni marzi ka size ka toolbox bana lain. 5. combobox ki propoerties m "ROWSOURCE" ki field m "sheet1!list" type karain. 6. Toolbox m se command button ko select kar ka form m add karain. 7. Command button ki propoerties m ja kar Caption ki field m OK select karain kyun k button sa ok Ka kam lena ha. 8. button ki propoerties ma caption ka neeche "Default" ki field ko "TRUE" kar dain. 9. Form m command button par right click karain aur "viewcode" ko select karain. is ki window m mojood code ko is code se replace kar dain. Code: Private Sub CommandButton1_Click() ActiveCell.Value = Me.ComboBox1.Value Unload Me End Sub 10. again Insert k menu m sa Module select karain aur ye code paste kar dain Code: Sub ChooseValue() UserForm1.Show End Sub 11. Close VBA editor window 12. Developer k tab m sa Macro Select Karain. aap ko "Choose value" ki macro nazar aae gi. is ko select karain aur option m jain. 13. option m shortcut key m ctrl+"l" (L) assign kar dain. ab jab bhe aap ko kahain paris list m sa name type karna ho tu "CTRL+L" press karain ge tu aap ki list aa jae ge aur ap pehle 2 ya 1 lafz type karain ge tu aap ko suggestion mil jae gi jesa aap chahte hain.AAp ko validation list ki zaroorat nahee rahe gi. " Mujh sa screen shot nahee bante is leye sorry." agar phir bhe masla ho tu apni file upload kar dain m kar daita hon. Is ka elawa bhee aik aur method ha jo ka is sa bhee pecheda ha. I hope this will help you. regards syar
Bookmarks