$$Excel-Macros$$ Excel commands to Electronic user interface.

2014-07-16 Thread Cab Boose
Hi Looking for vba requirements for exporting commands (on, off, etc) to a relay board for control of led lights etc. Can someone send me in the right direction etc. Do I need an add-in or activate some controls. Using 2000 at the moment but shortly onto Excel 2013. Thankyou Charles Harri

$$Excel-Macros$$ Data Logging

2014-07-16 Thread Cab Boose
Hi There are a lot of commercial software based around Excel for live logging of incoming data from instruments etc. Where can I find a site that covers the vba required for receiving data. Say direct from data recorders and/or thru SMS and a website. That is a temperature is sent by SMS from a

$$Excel-Macros$$ SMS messages into Excel

2014-06-25 Thread Cab Boose
Hi Have found plenty of programs to send emails/sms from Excel. I need however something that will receive sms messages and then I will combine with the map options to show positions and locations etc. Looks probably like Power View Intereactive Maps. Any comments on that would also be appreci

$$Excel-Macros$$ Excel On Line with VBA

2014-06-20 Thread Cab Boose
Hi Microsoft 2013 version available online with VBA editing (see http://blogs.office.com/2014/04/14/weve-updated-excel-online-whats-new-in-april-2014/ but you cannot create a macro online. Like fully use the online version without requiring own excel on pc. Is there anywhere with full online ?

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, wrote: > Today

$$Excel-Macros$$ Excel to Import from SmartSheet

2014-01-11 Thread Cab Boose
I want to use an Excel workbook with 2 or 3 sheets with different small databases. One of the databases is to come from the web, from a SmartSheet spreadsheet. Once the data into the .xls sheet I will run a macro to run a report using vlookup etc To run the report I want a one button press to

$$Excel-Macros$$ VBA for Dynamic Range

2013-05-16 Thread Cab Boose
Hi Have this macro to take the See code below. Comes up with compile error on the last row: ActiveWorkbook.. Is it something to do in not having the sheet name ? If so it would have to be taken from the tab. (I now see it is referenced as sht.) or Is it something to do with the R1C1 re

$$Excel-Macros$$ Xl2000 and HID device using =myserver function

2013-02-02 Thread Cab Boose
Hi I think I may need some macros here as well. On this url there is a description of using HID devices in XL. http://www.aggsoft.com/usb-hid-logger/tutorials/usb-hid-to-excel.htm The description is: "Excel has built-in tools for getting USB HID data. All you have to do is specify the formula

Re: $$Excel-Macros$$ Re: VBA to Destination of Value only

2012-12-31 Thread Cab Boose
Thnkyou Guys for the codes. The code that Anoop sen t works very well, and I will go with that. Thanks for your help Lalit and Anoop Regards Charlie On Mon, Dec 31, 2012 at 7:45 PM, Anoop K Sharma wrote: > Please try the below one. > > Sub PasteValueOnly() > Dim rng As Range > Set rng

Re: $$Excel-Macros$$ Re: VBA to Destination of Value only

2012-12-30 Thread Cab Boose
Hi Lalit Have tried the code , same result. Getting the 'application defined or object defined error' message. Can you review for me. A mystery to solve. Thnaks Charlie On Mon, Dec 31, 2012 at 4:11 PM, Lalit Mohan Pandey < mohan.pande...@gmail.com> wrote: > Hi Charlie, > > You can copy on

$$Excel-Macros$$ VBA to Destination of Value only

2012-12-29 Thread Cab Boose
Hi I want to copy the values only to another sheet. Without .value on the end it copies thru with error messages. If I put . value on the end it comes up with message 'copy method of range class failed'. Do not want to use copy/paste special method. Want to use 'Destination" as shown. Shee

Re: $$Excel-Macros$$ Deleteing Rows based on single column contents

2012-04-06 Thread Cab Boose
olution I posted for you? > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Cab Boose > *Sent:* Friday, April 06, 2012 3:53 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Deleteing Rows

Re: $$Excel-Macros$$ Deleteing Rows based on single column contents

2012-04-06 Thread Cab Boose
AutoFilter > End With > End Sub > > Sub delrowsSAS() > Dim i As Long > For i = Cells(Rows.Count, 2).End(xlUp).Row To 5 Step -1 > If InStr(Cells(i, 2), "SETOUTS") > 0 Then MsgBox i 'Rows(i).Delete > Next i > End Sub > > Don Guillett > Microsoft

Re: $$Excel-Macros$$ Turn Tab Order on/off

2012-03-26 Thread Cab Boose
> > Give it a shot, and post back. I can try to help you debug it if you need > more help. It's kind of hard to do by email like this, though. > > > > Asa > > > > *From:* excel-macros@googlegroups.com [ > mailto:excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Turn Tab Order on/off

2012-03-17 Thread Cab Boose
Good Day Asa Are you able to assist with this for me. Would be greatly appreciately. Thanks Charlie On Wed, Mar 14, 2012 at 9:45 AM, Cab Boose wrote: > Hi Asa > At the moment the H1 setting makes no difference. The sheet works like > normal with the setting at activate or deactivate

Re: $$Excel-Macros$$ Turn Tab Order on/off

2012-03-13 Thread Cab Boose
, k37, e82, f82, h82, j82, e83, f83, h83, j83, e84, f84, h84, j84, > e85, f85, h85, j85, e86, f86, h86, j86, e87, f87, h87, j87, e88, f88, h88, > j88, e89, f89, h89, j89?**** > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macro

$$Excel-Macros$$ Excude some sheets in macro

2012-02-26 Thread Cab Boose
Hi See attachedI workbook. XL2000 Refer to summary sheet I am wanting to extract data from some sheets into summary sheet. I can exclude 1 sheet ok, but when I try to exclude others I get syntax error. The line of code with problem is: If Worksheets(k).Name = "summary", "forms", "admin" Then

Re: $$Excel-Macros$$ inventory sheet

2012-02-25 Thread Cab Boose
Hi I have opened the file for webandmacros workbook posted here. The first sheet for stock management is blank. No buttons/forms etc. The other sheets are ok and show the information. If I go to VBA to check the code for the VBA Project it asks for a password, which I do not know. Shoulod I nee

Re: $$Excel-Macros$$ Toolbar

2012-02-25 Thread Cab Boose
With .Controls.Add(Type:=msoControlButton, ID:=1) > .Style = msoButtonIconAndCaption > .Caption = "Run " & Split(strMacroNames, ",")(lngLoop - 1) > .OnAction = Split(strMacroNames, ",")(lngLoop - 1) >

Re: $$Excel-Macros$$ plz check and help on the attached sheet the Call Macro to combine the macros is not working...

2012-02-24 Thread Cab Boose
Hi You need to make the names of the macros in the call routine the same as the name in the Tools/Macro list. That is Fill1, Fill2 etc and not Macro1, Macro2 etc On Sat, Feb 25, 2012 at 8:00 PM, Mohammed Muneer wrote: > ** > > -- > FORUM RULES (986+ members already BANNED for violation) >

$$Excel-Macros$$ Toolbar

2012-02-24 Thread Cab Boose
Hi Xl2000 I want to add some macros to the existing'Tools' toolbar. Have looked at several on the net. JKP, Contextures, Vbax, etc. They seem to use mainly a floating toolbar. I just want to run a macro that says - Add this macro (from a list showing in current workbook) onto the 'Tool

Re: $$Excel-Macros$$ Find & copy row into New sheet

2012-02-16 Thread Cab Boose
End With > '=== > .Columns.AutoFit > End With > End Sub > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Cab Boose > *Sent:* Tuesday, February 14, 2012 11:55 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-M

Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

2012-02-15 Thread Cab Boose
t; Dim CurrentIndex As Long >> Dim MyInput >> MyInput = InputBox("Enter Column to Search eg D5") >> CurrentIndex = ActiveSheet.Index >> If CurrentIndex > 1 Then >> Sheets(CurrentIndex - 1).Activate >> Range(MyInput).Select

Re: $$Excel-Macros$$ VBA to return to Previous Sheet used

2012-02-15 Thread Cab Boose
End If > End Sub > > > > On Thu, Feb 16, 2012 at 11:41 AM, Cab Boose wrote: > >> HI >> >> Have this code: >> >> Sub GetColumnRef() >> >> Dim MyInput >> MyInput = InputBox("Enter Column to Search eg D:5") >> >>

$$Excel-Macros$$ VBA to return to Previous Sheet used

2012-02-15 Thread Cab Boose
HI Have this code: Sub GetColumnRef() Dim MyInput MyInput = InputBox("Enter Column to Search eg D:5") Sheets.Add.Name = MyInput End Sub Works well, but leaves the active sheet as the new sheet. That is the newly created sheet. How do I get it to return to the the sheet prevously used. May

$$Excel-Macros$$ Find & copy row into New sheet

2012-02-14 Thread Cab Boose
Hi Excel 2000 Attached workbook 'Sheet!List' tab. For standardising descriptions, (different users!) I need to be able to extract a string and copy /paste all instances into a new sheet, sheet to be named the string of the search. Full list 2000+ rows. eg If I am looking for 'Bolt' the ma

Re: $$Excel-Macros$$ Text Box - Properties

2012-02-06 Thread Cab Boose
** > > .TextBox1.Value = .TextBox1Cell.Value2 > > End If > > End If > > End With > > End Sub > > ** ** > > Private Sub Worksheet_Calculate() > > With UserForm1 > > If .Visible Then***

Re: $$Excel-Macros$$ vlookup in Text Box

2012-02-05 Thread Cab Boose
File... then send the > resulting .frm and .frx files? > > Thanks, > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Cab Boose > *Sent:* Sunday, February 05, 2012 9:10 PM > > *To

Re: $$Excel-Macros$$ vlookup in Text Box

2012-02-05 Thread Cab Boose
ther workbook---that which is > on-screen at any given moment. Avoid pitfalls that way. Whoops :) > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Cab Boose > *Sent:* Saturday, February 04, 2012 1

Re: $$Excel-Macros$$ Text Box - Properties

2012-02-04 Thread Cab Boose
* > > End Sub > > ** ** > > Private Sub Worksheet_Calculate() > > With UserForm1 > > If .Visible Then > > If .TextBox1.Value <> .TextBox1Cell.Value2 Then > > .TextBox1.Value = .TextBox1Cell.Val

$$Excel-Macros$$ Text Box - Properties

2012-02-04 Thread Cab Boose
Hi I have a userform open with a 'text box' . Want to link with a cell in sheet. However the 'text box' properties does not show a 'linked cell' heading. I am sure it use to. How do I restore the missing property or is there another text box I should use. Thks Charlie -- FORUM RULES (9

$$Excel-Macros$$ Cloud Storage

2012-01-31 Thread Cab Boose
Hi Is there anywhere online that MS Excel files can be stored and used. No look-a-likes but Excel. Freeware or low cost. Thanks Charlie -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

2012-01-10 Thread Cab Boose
gt; > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > On Wed, Jan 11, 2012 at 6:20 AM, Cab Boose wrote: > >> Hi >> >> Trying to get this to work. See below. Comes up with 'Invalid use of >> porperty' ati = i + 1 >>

$$Excel-Macros$$ List of Dynamic & named ranges in workbook

2012-01-10 Thread Cab Boose
Hi Trying to get this to work. See below. Comes up with 'Invalid use of porperty' ati = i + 1 I think the probem is in the Dim declaration for i.Has Dim i As Name, at the moment, have tried others instead of 'Name' no luck. Want to list all Named Ranges (including Dynamic) in

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-23 Thread Cab Boose
o >*DOUBLE CLICK ON ROW 4 TO SORT BY THAT COLUMN* *DOUBLE CLICK ON > Filename ROW in ANY COLUMN to OPEN that file* *Select Filename Row in Any > Column & click Kill button to delete file and row* > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *Fr

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-22 Thread Cab Boose
; ActiveSheet.Cells(RowN, 1).Value = SpecifiedDir > ActiveSheet.Cells(RowN, 2).Value = vFName > Next > End If >End With > End Sub > '--end of code - > > Looking forward to hear if this code works (or no

$$Excel-Macros$$ List all Excel Workbooks

2011-12-22 Thread Cab Boose
Hi There are plenty of solutions for listing open excel files. I would like to list all excel workbooks on my C: and F: drives. They are all over the place. My bad housekeeping! How do I get the complete address for each workbook ? either with a hyperlink or not. But do need to print out t

Re: $$Excel-Macros$$ VBA select data in BOLD

2011-12-17 Thread Cab Boose
lls(sr, "G"), LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , *SearchFormat:=*True).Row Thanks Charlie Harris > Don Guillett > SalesAid Software > dguille...@gmail.com > > > > > *From:* Cab Bo

Re: $$Excel-Macros$$ VBA select data in BOLD

2011-12-17 Thread Cab Boose
ress. Regards Charlie Harris On Sun, Dec 18, 2011 at 5:22 AM, NOORAIN ANSARI wrote: > Dear Cab Boose, > > Please use try function. > > Copy this formula and paste it in define name and provide name range * > IsBold > =GET.CELL(20,INDIRECT("RC[1]",FALSE)) &

Re: $$Excel-Macros$$ VBA select data in BOLD

2011-12-15 Thread Cab Boose
umns("g").Find(What:="email", After:=Cells(i, "G"), > LookIn:=xlValues, _ > LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row > 'MsgBox em > ms = Cells(c.Row, "g") & " " & Cells(ph, "g") & &qu

$$Excel-Macros$$ VBA select data in BOLD

2011-12-15 Thread Cab Boose
Hi Have addresses like this: (columnG) ABC COMPANY 123 Delta St Town Ph 0800123456 fax 234567 email1...@dfg.com Sometimes there are more rows with irrelvant informtation I want to select 3 of the rows : ABC COMPANY Ph 0800123456 email 1...@dfg.com And place them in a single row i

Re: $$Excel-Macros$$ Inventory management

2011-12-14 Thread Cab Boose
Hi Sushil I cannot get the link to open. Are you able to email to me a xl file ? Thanks Charlie On Wed, Dec 14, 2011 at 8:26 PM, sushil kumar wrote: > Hi Manhar, > > Please see this link http://31.222.142.10:8080/openerp/login?db=&user= > > Database:ManufacturingM > User: admin > password:adm

$$Excel-Macros$$ Import PDF into Excel

2011-11-12 Thread Cab Boose
Hi I would like to use the 'File-Open' command in Excel to bring in a pdf file and have it finish up in .xls format. Is there an add-in to do this automatically or a vba way to have it converted. Most of the on-line require the conversion to excel to be done before and creates its own workbook

Re: $$Excel-Macros$$ Paste into a Named Range

2011-10-19 Thread Cab Boose
fset(-2) = "" Then > tr = Cells(9, "m").End(xlDown).Row + 1 > br = Cells(Rows.Count, "M").End(xlUp).Row > Cells(tr, "m").Resize(br - tr, 2).Delete > End If > End Sub > Sub fixit() 'fire if event code stops working > Application

Re: $$Excel-Macros$$ Paste into a Named Range

2011-10-18 Thread Cab Boose
get code. Thanks and regards Charlie Harris On Tue, Oct 18, 2011 at 1:19 PM, Cab Boose wrote: > > Hi Don and ChilExcel > > Thanks for info. Don like earlier I have not put enough info. I should > learn from this. > > See attached workbook with comments. > > Th

Re: $$Excel-Macros$$ Paste into a Named Range

2011-10-17 Thread Cab Boose
t; > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Cab Boose > *Sent:* Monday, October 17, 2011 5:57 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Paste into a Named Range > > Hi > > I have a 2 cells in a row that I

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-17 Thread Cab Boose
to reverse direction of the motor" > .Value = Abs(CLng(Not -.Value)) > End If > End With > > End Sub > > > Regards, > > Sam Mathai Chacko (GL) > > * > On Sun, Oct 16, 2011 at 12:06 PM, Cab Boose wrote: > >> Hi Don & Sa

$$Excel-Macros$$ Paste into a Named Range

2011-10-17 Thread Cab Boose
Hi I have a 2 cells in a row that I want to copy into a named range (say 'serialNo') also only 2 columns. Do I have to do the vba xcell up routine ? or should I be able to paste into 'serialno' and it will go into next available row. I have tried recording copy/paste, select 'serialno' but

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-15 Thread Cab Boose
llett > SalesAid Software > dguille...@gmail.com > > *From:* Cab Boose > *Sent:* Friday, October 14, 2011 8:32 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Toggle a Cell value > > Hi Don and Sam > > Thanks for your input. > > I use

Re: $$Excel-Macros$$ Toggle a Cell value

2011-10-14 Thread Cab Boose
xit Sub >> If Target = 1 Then >> Target = 0 >> Target.Interior.ColorIndex = 4 >> Else >> Target = 1 >> Target.Interior.ColorIndex = 3 >> End If >> End Sub >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >>

$$Excel-Macros$$ Toggle a Cell value

2011-10-14 Thread Cab Boose
Hi eveyrone See attached sheet. For a 12 volt motor speed direction, Forward or Reverse I want to have a value of a cell to toggle back and forth between 0 and 1 and cell color also to change each time between green and red. Prefer to use a cell than use a toggle button, unless a toggle button

Re: $$Excel-Macros$$ Counter in a Cell

2011-09-04 Thread Cab Boose
m [mailto:excel-macros@googlegroups.com] > *De la part de* Cab Boose > *Envoyé :* dimanche 4 septembre 2011 03:05 > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Counter in a Cell > > ** ** > > Hi Everbody > > > > Thanks

Re: $$Excel-Macros$$ Counter in a Cell

2011-09-03 Thread Cab Boose
> Please find the attached file. I have used Spin button (Form Control). It > can be used another sheet linked with sheet 1 – H11 as you requested. > > ** ** > > *- Xcel Inspiration*** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@goog

$$Excel-Macros$$ Counter in a Cell

2011-09-02 Thread Cab Boose
Hi In attached Sheet1, I want the cell to count from 0 to 16 up and down in between. The count is of times up arrow and down arrow are pressed. To set speed from, 0 to 16 for model railroad project. Your advice appreciated. Thanks Charlie Harris -- ---

Re: $$Excel-Macros$$ Excel and Sending Digital Data (DDE ?)

2011-08-31 Thread Cab Boose
: > … or a driver ? > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Cab Boose > *Envoyé :* mardi 30 août 2011 05:56 > *À :* excel-macros@googlegroups.com > *Objet :* $$E

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

2011-08-30 Thread Cab Boose
when you click on this, it will be Show in > Add-in Menu bar when you need it can be use.. > > > > -- > Thanks & regards, > Noorain Ansari > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > On Tue, Aug 30, 2011 at 12:10 PM, Cab

Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other

2011-08-29 Thread Cab Boose
reply and attachment. > > However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris > > > > On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose wrote: > >> Hi OOPS >

$$Excel-Macros$$ Excel and Sending Digital Data (DDE ?)

2011-08-29 Thread Cab Boose
Hi once again This is totally new subject. I have model railroads. I would like to control from Excel.(there are some other software available but I would like to use Excel) I want to send from Excel to a bus wire digital information showing the loco number and direction of travel (fwd/re

$$Excel-Macros$$ Named Range to Dynamic with VBA

2011-08-29 Thread Cab Boose
Hi I would like to select an already named range and using a command button convert it to dynamic named range by columns and rows. Is this possible ? It would be a lot quicker than doing it manually each time. I failed to make a lot dynamic when I set them up. Appreciate your help, I am age

$$Excel-Macros$$ Stock Sheets x 2 to equal each other

2011-08-29 Thread Cab Boose
Hi I have in attached workbook: Has two worksheets- 'ByGroups' and 'ByAssly" The two sheets should be the same, however they are in different order. First Question: Which is the best way to find the differences between the two sheets as at the moment so that corrections can be made. Have search

Re: $$Excel-Macros$$ VLOOKUP or Similiar

2011-08-28 Thread Cab Boose
, Aug 29, 2011 at 11:18 AM, NOORAIN ANSARI wrote: > Dear Cab, > > If possible please provide a sample sheet.. > > On Mon, Aug 29, 2011 at 4:22 AM, Cab Boose wrote: > >> Hi >> >> >> I have a list of data 5 columns 1000 rows. There are some blank rows in >&g

$$Excel-Macros$$ VLOOKUP or Similiar

2011-08-28 Thread Cab Boose
Hi I have a list of data 5 columns 1000 rows. There are some blank rows in this list. Sometimes one sometimes several. I do not want to delete the rows. I want a vlookup function or similiar, to lookup column A for the required number and copy into normal cell where formula is. That is: just a n

Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

2011-08-06 Thread Cab Boose
reinstalled and would not expect any add-in to be there. Thnaks Charlei On Sat, Aug 6, 2011 at 7:29 PM, Cab Boose wrote: > Hi Everybody > > Thankyou for all your suggestions. > > Still no success. Have tried new 'user', have reinstalled Office 2000, > have tried changi

Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

2011-08-06 Thread Cab Boose
gins else Create a New Login > Account and try...* > > ** ** > > *Best Regards,* > > *Venkat * > > *Chennai* > > ** ** > > On Fri, Aug 5, 2011 at 12:44 PM, Cab Boose wrote: > > Hi Venkat > > > > Thanks for the refe

Re: $$Excel-Macros$$ Excel 2000 will not Open - Advice needed

2011-08-05 Thread Cab Boose
ks See if helps... > > > http://www.leonelson.com/2009/08/25/windows-cannot-access-the-specified-device-path-or-file-you-may-not-have-the-appropriate-permissions-to-access-the-item/ > > > *Best Regards,* > *Venkat * > *Chennai* > On Fri, Aug 5, 2011 at 10:16 AM, Cab Boose

$$Excel-Macros$$ Excel 2000 will not Open - Advice needed

2011-08-04 Thread Cab Boose
Hi I am using Win7 and Excel 2000. Have never had problems for years, but now all of a sudden Excel will not open. Comes up with : "Windows can not access the specified device, path or file." I have been advised to reload Office 2000. A couple of questions: 1. Do I reload all of Office 200

Re: $$Excel-Macros$$ HI --help me

2011-07-24 Thread Cab Boose
Hi Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet in one click. Magic. Charlie On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI wrote: > > > Dear Vijay, > > Please find Error remover technique. > > * Errors-World* Error Type > Erro

$$Excel-Macros$$ VBA Macro with Input Box

2011-07-22 Thread Cab Boose
Hi Where can I find some good info on : When a macro runs I want a input box for user to insert the column range A:(or B; or F: etc) and then a input box for the text to look for say ABC or 123 or xyz etc and then a third box for the column for a format to be done. Have googled but have not

Re: $$Excel-Macros$$ Data Input Sheet - Deleting Entries - all added data deletes

2011-07-21 Thread Cab Boose
Hi Ashish Thanks for that. How do I toggle the 'TabOrder' on ? At the moment the tab order is not working. Thanks Charlie On Thu, Jul 21, 2011 at 7:08 PM, ashish koul wrote: > try this > > > On Thu, Jul 21, 2011 at 11:36 AM, Cab Boose wrote: > >> Hi Rajan &

Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In

2011-07-20 Thread Cab Boose
Hi Daniel Works perfect. I am very pleased with your help. Regards Charlie On Wed, Jul 20, 2011 at 10:04 PM, Daniel wrote: > My last effort ; see attached file. > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la

$$Excel-Macros$$ Data Input Sheet - Deleting Entries - all added data deletes

2011-07-20 Thread Cab Boose
Hi everyone Excel 2000 Win7 I am using code below to enter data onto a sheet. The sheet works well in entering data, but when you go back to an entry above and delete the current data and put in the correct data, on the delete key it deletes all data entered and user has to start over again. Ho

Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In

2011-07-19 Thread Cab Boose
cel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Cab Boose > *Envoyé :* mardi 19 juillet 2011 06:27 > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In > > ** ** > > Hi Daniel**

Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In

2011-07-18 Thread Cab Boose
> > .Width = .Width / 2 > > End With > > End If > > Res = Target.Address > > With Target.Comment.Shape > > .Height = .Height * 2 > > .Width = .Width * 2 > > End With > > End Sub**** > > ** ** &g

$$Excel-Macros$$ Comments Boxes - Temporary Zoom In

2011-07-18 Thread Cab Boose
Hi Ashish and all I have a spreadsheet (thanks to Ashish) that uses comments boxes. The size of the box is great. But on some occassions the user will want to see a larger box. I know it can be increased thru edit and resize etc but is there a way to say have a right click where the size could

Re: $$Excel-Macros$$ VBA Comment Box - Copy of

2011-07-12 Thread Cab Boose
Whole) >> >> If Not x Is Nothing Then >> >> Set Var = x.Offset(, 1) >> >> x.Offset(, 1).Copy >> >> Rg.Offset(, 2).PasteSpecial Paste:=xlPasteComments >> >> End If >

Re: $$Excel-Macros$$ VBA Comment Box - Copy of

2011-07-11 Thread Cab Boose
Hi Is someone able to comment on my problem as below. Tried to contact Daniel with no luck. Thankyou Charlie Harris On Fri, Jul 8, 2011 at 1:13 PM, Cab Boose wrote: > Hi Daniel > > Thanks for code. Have done as you suggest and installed in the Shipments > wb. When I run the c

Re: $$Excel-Macros$$ VBA Comment Box - Copy of

2011-07-07 Thread Cab Boose
** >> >> Set Var = x.Offset(, 1) >> >> x.Offset(, 1).Copy >> >> Rg.Offset(, 2).PasteSpecial Paste:=xlPasteComments >> >> End If >> >> Next Rg >> >> End With &g

$$Excel-Macros$$ VBA Comment Box - Copy of

2011-07-07 Thread Cab Boose
Hi Have a photo in a comments box in Database.xls. Also have a vlookup in another workbook Shipment-New.xls to bring forward the text from the cell into the wb. This works great. I also want to bring forward the comment box in the same cell from Database.xls into Shipment-New.xls. Would li