Hi
I want to send, using a command button, 4 separate cell values as a string
(numerical only) from Excel 2000 (open) to another open program in Windows7
(in this case an Arduino micro controller program) but could be any other
open program on the Window OS.
Code will include the open file
Hi
ou
Anyone have a contact for Alex Cantu re his 'smiley face' vba on Youtube
Charles
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
Hi
XL2000
Have searched for this with no luck.
Have a column with figures entered by user and also some sub-totals as a
result of formula.
How do I have a formula to add all the entered figures only, excluding the
sub totals. Maybe sumif with is formula ?
Thanks
CharlesHarris
--
Are you
???
On Monday, May 18, 2015 at 12:27:13 PM UTC+5:30, sswcharlie wrote:
Hi
XL2000
Have searched for this with no luck.
Have a column with figures entered by user and also some sub-totals as a
result of formula.
How do I have a formula to add all the entered figures only, excluding
the sub totals
Hi
Excel 2000
Three small questions as to these small codes not working.
Want to make a new sheet and list all sheets with hyperlink to each sheet.
Code curteosy of member of this group. (slips my mind at the moment apologies)
Sub MakeHyperlinkIndex()
Dim ndx As Worksheet, X As Integer
Set
Hi
Is there any add-in for a different scroll bar to add within a sheet? I
would like to be able to change colors in 3 places. The 2 arrows, the
thumb, and the background. And also even use graphics jpg as background.
Excel2000 seems a bit limited to blacks and greys.
Thanks
Charles
Hi
For a hobby project controlling speed of model train, using Excel. Others
around but not using Excel.
Want to use a Android phone/tablet with Excel including VBA to send data
via the bluetooth to a Arduino.
Arduino and Excel programming ok, just want to be able to use via Excel the
Hi Vabz
Thanksfor good work in sorting for me.
Charles
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect. Code
off the net. Have tried some things but no luck. What have I missed
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect. Code
off the net. Have tried some things but no luck. What have I missed ?
Option Explicit
Private Sub CommandButton1-Click()
Dim
Hi Vabz and all
Works very well. Great work.
Thankyou
Charles
On Thursday, January 22, 2015 at 7:42:29 PM UTC+13, sswcharlie wrote:
HI
Have cells that have had serial numbers entered (up to 50 serial numbers)
each separated by a comma.
Is there a VBA argument that can take the cell
at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect. Code
off the net. Have tried some things but no luck. What have I missed ?
Option Explicit
Private Sub CommandButton1-Click()
Dim Range As Integer
Dim UsedRange
Hi Ashish
Thanks for your WB etc. My Excel2000 will not open. Are you able to
post .xls version which I can download.
Thankyou
Charlie Harris
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax' error. On row
+13, sswcharlie wrote:
HI
Have cells that have had serial numbers entered (up to 50 serial numbers)
each separated by a comma.
Is there a VBA argument that can take the cell and transfer each serial
number to its own cell.
Part of a larger VBA project. VBA rather than function wanted
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect. Code
off the net. Have tried some things but no luck. What have I missed ?
Option Explicit
Private Sub CommandButton1-Click()
Dim Range As Integer
Dim UsedRange As Integer
Sheets(RegionalAreas).Select
Thanks for the function options. Look great but I would prefer to do with
VBA
23,34,56,57,60... would
become
23
34
56
57
60
etc
Thanks
Charles
On Thursday, January 22, 2015 at 7:42:29 PM UTC+13, sswcharlie wrote:
HI
Have cells that have had serial numbers entered (up to 50 serial
Hi
Have checked and this is all the code I had.
What I want the code to do is to put the last number in a list in the text
box on user form.
Thanks for your help.
Charles
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax
Hi Guys
Thanks for your replies. All sorted now.
Charlie
On Sunday, January 18, 2015 at 6:28:38 PM UTC+13, sswcharlie wrote:
Hi
Trying to get a macro assigned to open a userform. The macro does not
show in Macro Menu. Have tried some VBA in 'Workbook' visual. (off the
net)
Sub
Hi
Trying to get a macro assigned to open a userform. The macro does not show
in Macro Menu. Have tried some VBA in 'Workbook' visual. (off the net)
Sub...
UserForm1.Show
EndSub
but userform still does not show.
How do I get the userform1 etc to show in Macro Menu ?
Thanks
Charlie
--
On Sunday, December 30, 2012 8:45:51 PM UTC+13, sswcharlie wrote:
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
Hi Guys
Wow, they work like magic. Thanks Ashish and Rajan.
Some more new knowlege for me.
Great work and thanks
Charlie Harris
On Aug 26, 5:58 pm, Rajan_Verma rajanverma1...@gmail.com wrote:
Try this:
Sub SortList()
On Error Resume Next
Dim Record As Integer
Record =
Hi
I want to post a message with .xls file attached. Where is the button
to add attachments to email ?
Thanks
Charlie
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
the sheet.
so we can help you better
On Thu, Jun 30, 2011 at 6:29 AM, sswcharlie swch...@gmail.com wrote:
Hi
Have a photo in a comments box in wb 2. Also have a vlookup in
another workbook WB1 to bring forward the text from the cell into
WB2. This works great. I also want to bring forward
Hi
Have a photo in a comments box in wb 2. Also have a vlookup in
another workbook WB1 to bring forward the text from the cell into
WB2. This works great. I also want to bring forward the comment box
in the same cell from WB2 into WB1.
Would like to use vlookup function but I believe not
Hi
Is it possible to have say a cell with hyperlink to sheet (that is ok)
but also if the name in that cell changes it stays as a hyperlink to a
another sheet.
eg if A1 has 'Sheet2' hyperlinked, and then A1 changes to 'sheet3'
will the hyperlink change to sheet 3 ?
Thanks
Charlie
--
Hi
Part of a another code -
I want to find the value(text) in active cell (value changes often) in
workbook (except current WS and one other worksheet 'home) and
delete. Could be more than one instance.
Thanks
Charlie
--
, sswcharlie swch...@gmail.com wrote:
Hi
Part of a another code -
I want to find the value(text) in active cell (value changes often) in
workbook (except current WS and one other worksheet 'home) and
delete. Could be more than one instance.
Thanks
Charlie- Hide quoted text
26 matches
Mail list logo