Search results for query: *

Hello! I am looking to create a button on my custom bar that once clicked will bring up a list. So, for example, if I hit Button1 then it will bring up a list with List1 and List2 which I will correspond to some macros that I have recorded.

Hello, I have recorded three macros which create a pivot table one after the other on the sheet "Results". For some reason, sometimes it works and other times it crashes. I think it has something to do with the pivot table name - but I changed these. Here's my code: Sub CreateGrid()...

How can I do the following: If a user enters an age via a userform. I want to search through two columns, D & E. for that value. The best way is to run through both the list and if it equals that value, put a "YES" or "NO" in column F and then autofilter that column. So...

On my userform I have a box where the user has to enter a date in the following format: dd/mm/yy Is there any way to prompt the user to type in the date in that format, i.e. --/--/-- where the user can only type over the "--"?

Hello! I am trying to use the autofilter with variables. Here's my code: Selection.AutoFilter Field:=7, Criteria1:=&quot;>=low&quot;, Operator:=xlAnd _ , Criteria2:=&quot;<=high&quot; low and high have values, but I am not sure where to put the &quot;&quot;. I tried taking them out but I get...

I am having many troubles with userforms! My second field on the form is called agedate. This needs to be in the format dd/mm/yyyy and depending on this date entered I want to search the worksheet (column D) for anything that has that date entered including 2 days either side. Is this...

Hello! I have created a userform for the first time and require some help. Firstly, how do I add data to the drop down list? Secondly, based on this selection how would I filter for that data (which is in column A). Thanks You!

Hello, I am new to XML and require some help. I have a txt document which is published to the web and would like to create a search facility. The txt document has about 20 columns. How would I go about doing something like this? And is XML the way to go? Thank You, Navvy

I have the following formula and I am trying to convert it into code using a do...while loop. The formula is: =IF(ISNUMBER(M1),MIN(ABS(LN(M1/N1)),ABS(LN(L1/N1))),ABS(LN(L1/N1)))*R1 I need this to calculate for all cells until the last empty cell is found and put the value in column D. I...

Hello! I am wondering if we can interpolate values given that we have certain values. For example: TODAY: 10 1 WEEK: 13 3 WEEKS: 18 7 WEEKS: 32 Say I wanted to find the value for 6 weeks (or any others), how could I do it? Thank You!

Hello. I am trying to find a method whereby I can display certain information on one sheet from an entire list on another sheet. So, if I have the following list on &quot;Sheet2&quot; John 1234 abcd Tim 4345 jhgd John 8989 jwek John 4444 ouuu etc, etc The list on &quot;Sheet2&quot; is...

Good Morning All, I am trying to send a mail via the following code: Sub sendMail() Dim sj As String sj = &quot;Today&quot; ActiveWorkbook.sendMail Recipients:=&quot;Nav, Ben&quot;, Subject:=sj End Sub I have tried: Application.CommandBars(&quot;Custom 1&quot;).Visible = False But...

Hello, I have the following piece of code which checks that if Column 7 is NOT within 1% of column 11 or column 12 then delete. The problem is the value in 11 or 12 could be a zero and we can't divide by zero. How can I do something that says if Col. 11 is zero skip that and look at 12 or if col...

Each day I enter 3 tasks. In the morning, I save the first task with the subject title: Salt (and I put in the Due Date as &quot;today&quot;). In the afternoon, I save the second task with the subject title: Lemon (and I put in the Due Date as &quot;today&quot;) In the evening, I save the...

I am trying to develop a form in Outlook 2000. In the form I have 3 tabs, all of which have 4 text boxes each. I need to be able to copy and paste a diagram into the mail message. I can only do this in the &quot;message&quot; box. But, I am only allowed to put the &quot;message&quot; box once...

Hello all, I'm trying to create a form in Outlook. I have 4 tabs at the top. And under each one, I have created several text boxes. I can only put one message box (the one with the scroll bar on the side) in the whole form. Is there any way to have more than one of these message boxes. Thanks.

Hi, I'm trying to force Uppercase in Excel. I believe the function is UCase. Has anyone been able to do this before?

I'm trying to create a form in Outlook but cannot find any help on this. Can you help?

Hello all, I'm looking for some code that waits for 60secs then after the 60 secs a msgbox appears. I have the following but I'm not sure if it is useful: newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 5 waitTime = TimeSerial(newHour...

I finally have a way of permanently highlighting a row if two cells match, even if the workbook is inactive. Here is the code I used (pretty straight forward!): Private Sub Worksheet_Calculate() If Range(&quot;D1&quot;) = Range(&quot;E5&quot;) Then Range(&quot;A5:L5&quot;).Select With...