Is é an Código VBA: Déan liosta de na roghanna atá ann cheana féin nó Excel, is é an ceart atá agat ná an fhoirm iontrála, an méid atá i 'MsgBox' agus an méid atá leagtha síos de 1 cholna, agus an méid atá leagtha síos de na cinn is fearr a bhfuil an t-ainm bunaidh acu. possivel fazer agus modhnú gan cód.
Sai 'MsgBox "An iomarca iomalartaithe!", vbInformation, "Kutools le haghaidh Excel"' Is é an rud a d'fhéadfadh a bheith agat ná an t-athrú a dhéanamh
Entra 'seleção de 1 coluna/linhas.
eiseamláir
roghnúcháin lín 12345678 permutar 5 das 8 leanúint mar sin nó cód.
12345
críochfort 87654.
Sai 'MsgBox "An iomarca iomalartaithe!", vbInformation, "Kutools le haghaidh Excel"' Is é an rud a d'fhéadfadh a bheith agat ná an t-athrú a dhéanamh
Entra 'seleção de 1 coluna/linhas.
eiseamláir
roghnúcháin lín 12345678 permutar 5 das 8 leanúint mar sin nó cód.
12345
críochfort 87654.
'Sub
GetString()
'Updateby Extendoffice
Dim
xStr
As
String
Dim
FRow
As
Long
Dim
xScreen
As
Boolean
xScreen = Application.ScreenUpdating
Application.ScreenUpdating =
False
xStr = Application.InputBox(
"Enter text to permute:"
,
"Kutools for Excel"
, , , , , , 2)
If
Len(xStr) < 2
Then
Exit
Sub
If
Len(xStr) >= 8
Then
MsgBox
"Too many permutations!"
, vbInformation,
"Kutools for Excel"
Exit
Sub
Else
ActiveSheet.Columns(1).Clear
FRow = 1
Call
GetPermutation(
""
, xStr, FRow)
End
If
Application.ScreenUpdating = xScreen
End
Sub
Sub
GetPermutation(Str1
As
String
, Str2
As
String
,
ByRef
xRow
As
Long
)
Dim
i
As
Integer
, xLen
As
Integer
xLen = Len(Str2)
If
xLen < 2
Then
Range(
"A"
& xRow) = Str1 & Str2
xRow = xRow + 1
Else
For
i = 1
To
xLen
Call
GetPermutation(Str1 + Mid(Str2, i, 1), Left(Str2, i - 1) + Right(Str2, xLen - i), xRow)
Next
End
If
'End
Sub