Search results for query: *

Hi Building some UserForms into excel and using also DTPicker component. As by default I saw today's date in field then googled and found way to set date field empty and "force" user to select proper date. Code I used: With Me.DTPicker1 .CustomFormat = " " .Format = dtpCustom End With]With...

Does anyone know or have good idea how to make following comparison simpler than manually? Input data: V1 V2 V3 V4 V5 V6 E1 1 4 3 2 6 5 E3 2 1 3 4 5 6 Output table: V1 V2 V3 V4 V5 V6 V1 0 1 2 2 2 2 V2 1 0 1 1 2 2 V3 0 1 0 1 2 2 V4 0 1 1 0 2 2 V5 0 0 0 0 0 1 V6 0 0 0 0 1 0 Explanation: Logic...

Hi one question about goal seek - some cases using simple goal seek command,it fails to find an answer / solution. Does someone has any idea how to overcome from that issue? Currently I just rounded expected result to nearest multiplier 10. So it works better than previously but of course it...

Hi I have starting number 0 and max number 3. After pressing Start system will start adding 0,25 until total sum is 3, then system stops working. Do to it, I used LOOP and as I didn't know how to do it simply I used following logic - Add 0,25 to into first cell Add 0,25 to next free cell...

Hi I made one excel, where you can add data through pop-up window. Added data will be copied into excel sheet. After that I'm making some of calculations etc. Problem is that output from user-form is in text, so entered number 10.23 is text for excel and I can't use SUM formula to sum-up...

Hi I have VBA command: Private Sub CommandButton1_Click() Dim LR As Long Range("s3:s12").Copy LR = Range("t" & Rows.Count).End(xlUp).Row + 1 With Range("t" & LR) .PasteSpecial Paste:=xlPasteValues End With Application.CutCopyMode = False End Sub Problem is that in Range("s3:s12") I have also...

Hi, trying to build VBA code to change legend(s) color after changes in worksheet. I have made following code but I received error - Run-time error '438' Object doesn't support this property or method. By pressing debug it shows that there is something wrong with lines With Selection.Border...

Hi, I made excel and VBA code under Excel 2003. Everything worked ok. Now I have excel 2007 and I have problem with one VBA code or one part from it. Code is: Public vartimer As Variant Const TimeOut = 200 Sub Salva1() Call update Call Tempo1 End Sub Sub Tempo1() vartimer =...

Hi, I would like use VBA code to protect excel worksheet and same time give users option to format cells, columns, rows. I have recorded two different VBA codes but don't know how to merge them. Maybe someone can help? First code: ActiveSheet.Protect DrawingObjects:=True, Contents:=True...

Hello, Different countries use different computer settings to seperate decimal points. Some country will use comma, some country point. Is there any possibility to force excel to understand what kind of setting user is using? I mean that I would like to insert to cell formula that if system...

Hello (again :)), I have used this kind of formula =ROUND(H11;0)&" "&Sheet2!V7 Where H11 is number and Sheet2!v7 is some text line. (Also used so, that text is before number or even so that text is before and after number). This calculation will show me number and text in one cell, it is...

Hello, I have such problem with excel that I do not even know how to look solution for it :) Problem is that I have wrote command - =IF('IX Suggestions'!$O$3=Sheet2!$B$3;$V$7;Sheet2!$V$6)&" in month" Everything did work ok, it did show correct answer and so on. But suddenly this commant...

Hi, I tried to make a VBA code which would autofit all rows in worksheet. I wrote this kind of code: Private Sub Worksheet_Calculate() If Range("A3") = 1 Then Rows("3:3").Select Selection.Rows.autofit Range("A3").Select End If End Sub In worksheet A3 = B1 Problem is...

Hy, I use under validation command indrect command. It all works fine. basically i have =indirect(K1) K1 = If(L1=1;"One";if(L1=2;"Two";if(L1=3;"Three";""))) One = A3:A7 Two = B3:B6 Three = C3:C9 Now I decided to change this validation littlebit, so I inserted some assistance lines to use...

Hy, I moved some of data out from main workbook. I linked data beatween two workbook simple way for A2=[workbook2]'Sheet1'!A2 Most of links work very good but some links wouldn't update data. I see just #NA. This error don't change even if I go under edit menu to link menu and update there...

Hi, I recorded with macro recorder VBA code wich will change data range in chart. Code is like this: ActiveSheet.ChartObjects("Chart 1").Activate ActiveChart.PlotArea.Select ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("B2:L5"), PlotBy:= _ xlRows...

Hy, maybe anyone had somekind of problem and knows good solution :) Problem is that closed excel workbook doesn't to calculations. I moved calculations from one workbook to an other workbook because maybe in the future I need to make some changes in calculation sheets. As this main workbook...

Hy, is it possible to force macro run when I use validation in excel sheet?

Hy, I mada e excel workbook, where I also inserted one other excel workbook sheets. Everything is noce but in other workbook will be data update once in month. Today I just moved (copyed) all that workbook sheets into my prime workbook. Right know I should once in a month update one sheet...

Hi, I have made excel workbook, where are lots of sheets and some macros also. I protected both sheets and workbook with password (I used different password just to make thing littlebit safer), so to make little harder to get hidden part of workbook. But, :), I use very much grouping and...