$$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

2014-06-15 Thread Noah Shalii
Sorry I'm an excel noob, I don't understand what to do. On a side note though, i was wondering what the formula would be if it was just to find whether Cells(1, 1).Value exists in row B, and where it would be. Also what would the formula for selecting the bottom row with a value in it be?

Re: $$Excel-Macros$$ Re: Need help with making a macro revolving around finding certain numbers from a list

2014-06-15 Thread Vaibhav Joshi
Hi You need to use count if formula to get what you want..in range you need to specify both the column where probable value would be. Refer file in my previous post with yellow colored range. Cheers!! On Sun, Jun 15, 2014 at 12:02 PM, Noah Shalii koukinom...@gmail.com wrote: Sorry I'm an

$$Excel-Macros$$ Event for dynamically add control in Excel VBA

2014-06-15 Thread Ondřej Říha
Hello, I would like to add sub for click event of dynamically add control button in user form for example in VBA for Excel. I found some examples on Internet but every finished with some error or didn't work. When I use for example this way:

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 updates in 7 topics

2014-06-15 Thread Cab Boose
Hi Having a problem with Google Groups. Using Chrome Win7 To send a new message it comes up with email to, Subject heading, tags to enter, but there is no message block! to type in a message. Is there something I am missing ! Charles Harris On Mon, Jun 16, 2014 at 11:23 AM,

$$Excel-Macros$$ Conditional formatting

2014-06-15 Thread N.Shivkumar
Dear friends Can anybody throw some light and help me as to where I am going wrong in conditional formatting! N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Conditional formatting

2014-06-15 Thread Vaibhav Joshi
whats issue? On Mon, Jun 16, 2014 at 11:12 AM, N.Shivkumar shiv1...@gmail.com wrote: Dear friends Can anybody throw some light and help me as to where I am going wrong in conditional formatting! N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: