Flashcard System For 2 Languages

Jul 27, 2006

I'm currently studying japanese and I need to make a flashcard system so that I can memorise words a lot faster. An old friend told me that it is possible to make a flashcard system in excel (or maybe Access due to its database system - I cant remember which sorry). I'm looking at a basic system that first shows me the japanese - then i click it and it reveals the english, click the english and it then moves onto the next japanese word etc etc. Though, I have no idea where to start in building such a system, my excel knowledge is not great but it I'll give anything a try

View 2 Replies


Switching Languages

Nov 25, 2006

Working for a dutch company and using a lot of excel and access it is sometimes a pain that when you are looking for functions. for example "left(b3;3)" in dutch is "links(b3;3)" now this is an easy one but some are hard to guess.

I wrote some neat code which condionally formats cell's in an Excel range and dependend on a value in column "Q" (= status) then sets the color of the field. it works fine

However when working with an english version of Excel I need to use "left" instead of "links"

how to check the local settings for Excel?

'Conditional Format status cell's
.Range("G4:P" & (xRcount + 3)).Interior.ColorIndex = 4
iRow = 4
iRow2 = 4

View 9 Replies View Related

Languages Identification Aid

Nov 16, 2006

One Excel file with two columns that is populated with a description code and a description. The total number of lines is 30 000 and the description is on the Languages of English, Spanish and Portuguese.

I need to indicate in the third column all the descriptions that are not English.

View 6 Replies View Related

Switching Languages: Formulas Vs. VBA

Jan 21, 2009

I am currently creating a massive bilingual report using Excel based on data gathered from a customer visit, as most of the engineers are non-native English speakers, and most everywhere else in the world wants reports in English. Currently I am using this roundabout method:

I have a lookup Table sheet: .....

View 10 Replies View Related

Translate Formulas Between 12 Languages

Feb 9, 2007

It looks like the above has been inserted into my current workbook (by mistake). How do I delete it all (lots of the options have the remove option disabled)

View 3 Replies View Related

Macro To Do A Global Replacement Dependent Of Languages

Nov 22, 2006

How could I have a macro which translates formulas on file open since Excel doesn't do it itself for functinos from add-ins like YEARFRAC?

View 9 Replies View Related

Create A User Defined Enumerated Type Typically Used In Other Languages

Apr 18, 2007

I am trying to figure out how to create a "User-Defined" enumerated type typically used in other languages (other than VBA).

for example in Java a typical enum type is declared like this:

This gives the benefit of writing "readable" code.

(back to vb)

If Season SUMMER then
call wear_a_sweater
end if

View 9 Replies View Related

Points System

Jun 27, 2007

Currently I'm working on a prediction game using excel. Can excel do the tabulation itself(Points awarded) if I just key in the result? Can anyone help me? Thanks in advance.
Examples below,

Result 3-1

Name Predicted Scored Points
Alex 3-1 5
Brian 4-1 4
Charlie 2-0 3
Derrick 3-3 1
Eric 0-2 0

Point System:
1 point for correct goals/no goal by either both teams
3 points for correct result ( Win, Lose, or Draw - say result is 3-1, 3 points if you predicted a Chelsea 2-0 win)
5 points for correct match results
No points for incorrect score and results.

View 14 Replies View Related

Booking System

Mar 12, 2008

I'm trying to create a lesson booking system,

View 11 Replies View Related

Points System..

Nov 15, 2009

I m trying make a spreadsheet up to fine the following i have also included a file
raymond ran 11 seconds so he gets 150 points which is .6 of a second better than his Personal best time (PB's) but matt ran 13.6 seconds but it is 1.1 seconds slower than his Personal best time so he is minus 275 for every .100 of a second they get 25 points added or taken off

View 2 Replies View Related

Looking For ELO Rating System?

Nov 23, 2013

Im looking for a ELO rating. Its a system which they often use with Chess.

View 3 Replies View Related

Numbering System

Oct 19, 2009

Wondering if there is a formula for Excel that could replicate a numbering format like in Word?


and so on...

Idealy I would like to go farther than the 3rd level.

View 6 Replies View Related


Feb 20, 2007

Below is a formula that links other worksheets from other workbooks to cell B4. If I copied this to another computer system in My Documents that is named other than Tom would the links get updated to that system. If not is there a macro that can handle this to be updated to another computer system.


View 9 Replies View Related

System Of Equations

Apr 19, 2007

how the Process to solve the following problem:

1A = 15x + 32y + 5z
1B = 6x + 2y + 8z
1C = 3x + 11y + 19z ...

View 9 Replies View Related

Setup New Inventory System?

Aug 26, 2013

We have 100+ clients. Each client has inventory in our warehouse. Every day we write down how many items went out to our client on a piece of paper and subtract that number to get a balance inventory. When we run low, we order more on a new FO number. What is the best approach for tracking this? I was thinking one way is to put our clients in a drop box at the top of the page and then the data will appear at the bottom, however I can't get that to work. I am trying filters to see, but I am unable to subtract the balance automatically from the last FO# and from the correct area.

Is there a way to choose a client and product at the top of the page and have the tracking below?

View 5 Replies View Related

Create System To Measure KPI?

Jan 3, 2014

I am looking to create a system to measure KPI (key performance indicators). I need to include a weekly target and then measure performance for that week against the target. I want to create a form to make data entry simple, how best it would be to implement using excel. Would I have 2 tables, one for targets and one for performance and then use look ups.

View 9 Replies View Related

Soccer System And Dates

Feb 28, 2007

Ive got an example below of how i'm sorting fixtures and how to determine winners/losers and draws.

******** ******************** ************************************************************************>Microsoft Excel - Book2___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutF1G1H1F2G2H2F3G3H3F4G4H4=
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box

What I'm struggling with is the ability to change dates and still be able to add the teams figures up.

When adding, for instance, Team A's wins I'm using

and similar for defeats and draws.

But when I change dates, for instance game 3 to the 10th, Team A is still counting F1 and F3 yet its games now in row 1 and row 4.

How can i get it to change with the sorting.

Im sorting fixtures via the sort feature in data.

View 9 Replies View Related

Using VBA To Select An Option In A System Msg Box

Oct 6, 2007

I have a button in a template file (.xlt) that will save the file as the customer name in cell C4. That template file feeds an Access database and when you save the template file you are prompted with the following system message:

If record DOES NOT exist in DB:

If record DOES exist in DB:

My code is as follows: ....

View 9 Replies View Related

Enter System For The DF Part

Jan 10, 2008

In MS Query:

Like '%ST%DF%'

Works fine.and returns:


I want to use the [Enter system] for the DF part.

When I try to use the following in MS Query:

Like '%ST' & [Enter Sys] & '%'

the pop up window appears but after entering DF
I receive an error: Missing Right parenthisis or illeagal variable?

View 9 Replies View Related

Add The System Time To A File Name

Feb 25, 2009

How do I add the system time to a file name

ChDir "S:ProductionProduction Request Forms"

ActiveWorkbook.SaveAs Filename:= _
"S:ProductionProduction Request Forms" & SaveWorkbook & "_Request" & Time & ".xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

View 9 Replies View Related

Interesting System Error

Mar 3, 2009

The macro below will generate a System Error '-2147417848 (80010108)' when executed as shown below but only when there is a value in the 6th column that ends in .0006(or .00061). It will however run if no empty cells are present after the cell with .0006 in the 6th column (i.e. J = 1 to 6). This can be avoided by using the "On Error Resume Next". What is strange is if the value ends in anything other than .0006(or.0061) in the 6th column it will work fine (i.e. .00062 or .0005).

In a new workbook I have the following values in A1:B6
1125924.4684333.2496895-1217.935514LOFT -1785884.895
2422123847.627 221.0003 -482.8184125LOFT -1698521.0006

The Macro:
Sub Macro1()
'On Error Resume Next
Application.Calculation = xlCalculationManual
Set OldWb = ActiveWorkbook
Set NewWb = Workbooks.Add
Application.ScreenUpdating = False
For I = 1 To 2
For J = 1 To 7
NewWb.Sheets("Sheet1").Cells(I, J) = OldWb.Sheets("Sheet1").Cells(I, J)
Next J
Next I
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub

View 9 Replies View Related

Getting Username From System In A Cell

Apr 17, 2009

I am trying to get the username from the system to display in A1 in a file in Excel. I got this code form internet and put it in the sheet by clicking right mouse on the sheet1 tab and view code and then pasted it there.

Function UserNameWindows() As String
UserNameWindows = Environ("USRNAME")
End Function

And then as per the instructions on the same page I inserted this formula in A1 : =UserNameWindows()

The person stated that by doing this, I should be able to get user name displayed in A1. BUt all it gives me is #NAME?.

View 9 Replies View Related

Points System Using Nested Ifs

Jun 12, 2006

I am trying to work out a point scoring system and have the following formula =IF(OR(C9="",F9="",'Winning Scores'!C7="",'Winning Scores'!F7=""),0,IF(C9+F9='Winning Scores'!C7+'Winning Scores'!F7,"3","0")+IF(OR(AND(C9>F9,'Winning Scores'!C7>'Winning Scores'!F7),AND(AM!C9<AM!F9,'Winning Scores'!C7<'Winning Scores'!F7)),1,0))

Which is basically saying that if C7 and F7 = C9 and F9 in the 'winning scores spreadsheet, to give 3 points but it is returning 3 points if C7=F9, and I only want it to relate to C7 - do you know how I would do this?
I also need to award 1 point if the highest score is chosen but not if the exact score, hence if the score was '3' '2' and the person chose these exact numbers 3 points would be awarded but it they chose '3' 1' only 1 point would be awarded as they chose the winning team

View 5 Replies View Related

File System Object

Feb 14, 2007

how the "File System object" works in Excel?

I have a various information in one log file, which need to import to excel. So it's i need to declare all fields i need?

View 8 Replies View Related

Creating Ranking System

Mar 27, 2007

I am trying to create a spreadsheet that will automatically create a ranking system after data is input manually.

If you look in the example, you'll see roughly 30 people will be ranked on various metrics, and on another sheet, I would like 1-30 to be displayed in each of the different metrics, thus creating a ranking.

I'm not sure how to go about doing this, and any help would be greatful. I've tried different excel tutorials and searched and searced the help features, but couldn't exactly find what i was looking for.

View 9 Replies View Related

Error 429. EXTRA.System

Jul 13, 2007

I've got this code that I use to open the active session of a program I use (EXTRA! 8.0). When I try to code it to open a specific new instance of the program, I get a run-time error 429. When I debug, it's stopping on the line where I get the new instance. I've searched on this issue, but I still don't understand what the problem is.

Sub log_in()
Dim Sys As Object
Dim Sess2 As Object
Dim lngOldSysTimeout As Long
Set Sys = CreateObject("EXTRA.System")
If Sys Is Nothing Then
MsgBox Prompt:="EXTRA! not properly installed on this PC." _
& " Terminating execution.", Buttons:=16, _
Title:="E!PC Not Properly Installed"
Exit Sub
End If
Set Sess2 = GetObject("C:Program FilesExtra!sessionsCCS2.edp")
If Sess2 Is Nothing Then
MsgBox Prompt:="DLC.edp not found. Terminating execution." _
, Buttons:=16, Title:="E!PC Not Properly Installed"
Exit Sub
End If
End Sub

View 2 Replies View Related

Detect Operating System

Mar 8, 2008

how can I detect the OS of the computer a sheet is running on and launch a macro accordingly?

I have built a calculator that utilizes an embedded wave file but doesn't work correctly with Vista. With Vista it actually causes WMP to be launched instead of just playing the file. So I was hoping to be able to skip the sound on Vista machines but play for all other OS's.

View 3 Replies View Related

Making Big Data System Into Table?

Jul 1, 2014

I have a big system of data, me not knowing better i have it such that the categories is listed in the start of the row, and new data for periods are listed in the columns following. when i mark the data and click table, it puts the scroll down thing on top of the columns, which is of no use to me at all, i need them at the start of the row. is this possible, or do i need to reorganize all the data, and VBA code used to sort and collect it ?

View 7 Replies View Related

Excel Calculation System With Two Factors

May 8, 2014

I am making an Excel calculation system where I have two factors (weight and opening length), which is essential for which lift there is possible to use.

There are 8 models each of which may have some limitations in terms of weight, and the opening length:

ModelPushing/pulling Force (KG)Stroke Length (mm)
HCV 130 350
HCV 230 600
HCV 330 800
HCV 430 1000
HCV 550 350
HCV 650 600
HCV 750 800
HCV 850 1000

What I am looking for is a formula, that when you enter numbers in two cells "Weight" and "Opening distance" of what their platform is to meet, then all the models that have the potential to accomplish this task pops up.

Example: A client writing a weight of = 40 kg and opening length of = 450 mm. The formula should then show which model that meets the requirements.

In this case: Models that meet the requirements for the lift.

ModelPushing/pulling Force (KG)Stroke Length (mm)
HCV 650 600
HCV 750 800
HCV 850 1000

View 5 Replies View Related

Solving System Of 3 Nonlinear Equations

Feb 12, 2013

I have a system of 3 equations with 3 unknowns that I would like to solve in Excel.

The equations are
24.792 = A*e^(B/(100-C))
9.857 = A*e^(B/(70-C))
4.590 = A*e^(B/(40-C))

Where e is the exponential function.

View 7 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved